Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: TO_DATE problem....
Common mistake. The format for MINUTES is 'mi' not 'mm'. Try using
'mm/dd/yy hh24:mi:ss' for your format mask. Also, as a matter of taste, I
would recommend using a 4-digit year - i.e. 1998 and 'yyyy'. That way there
is no question what is meant.
--Mike