Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table myTable (name varchar(25), myDate DATETIME)
- insert into myTable (name,mydate) Values ('fred','jan 1 2009 13:22:15')
- '2007-01-01 10:00:00'
- yyyy-mm-dd hh:mm:ss.xxxxxx
- %d day of month: 00
- %f fractional seconds: SS.SSS
- %H hour: 00-24
- %j day of year: 001-366
- %J Julian day number
- %m month: 01-12
- %M minute: 00-59
- %s seconds since 1970-01-01
- %S seconds: 00-59
- %w day of week 0-6 with sunday==0
- %W week of year: 00-53
- %Y year: 0000-9999
- %% %
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement