Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
timetype
select
cast('2008-2-23' as date) as DATE_TYPE,
cast('12:20:30' as time) as TIME_TYPE,
cast('2008-2-23 12:00:00' as timestamp) as TIMESTAMP_TYPE
FROM
INFORMATION_SCHEMA.`SCHEMATA`;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment