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
%%  %