Skip to content

Instantly share code, notes, and snippets.

@xiaom

xiaom/gist:0ee335251727eed0cb0b

Created May 6, 2014 00:51
Show Gist options
  • Save xiaom/0ee335251727eed0cb0b to your computer and use it in GitHub Desktop.
Save xiaom/0ee335251727eed0cb0b to your computer and use it in GitHub Desktop.
Download ZIP
timetype
Raw
gistfile1.txt
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