Re: to_date format

MattJ83 wrote:
> On a closly related matter - i have managed to get the string to be
> converted into a date.
>
> 2006082109 - 21/08/2006 09:00:00
> 2006082110 - 21/08/2006 10:00:00
>
> however, when i read in a string such as:
>
> 2006082100
>
> it is being converted to:
>
> 21/08/2006
>
> the time is being left off completely. I thought as i stipulated
> 'YYYYMMDDHH24' in my code that is would output results from the 24hr
> clock and so would interpret 00 as 00:00:00.
>

Have you considered concatenating '00' to the end of your string and then using the format mask 'YYYYMMDDHH24MI'? I haven't tested it, but I'm not sure that Oracle truncates the minutes.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown