Re: Return minutes as date datatype

"Paul" <pd_oflaherty_at_nospam.hotmail.com> wrote in message news:2vKdnWh-C_GCfGLdRVn-qg_at_brightview.com...
| Thanks Mark
|
| I'm glad you understood what I meant!
|
| I can perhaps get by with the time prefixed with a date if the users are
| warned to ignore the date element (or I can somehow format it out in
| Access). For this approach to work I need the date part of all the
returned
| rows to be the same (I'm only interested in the time). Before I try this
| approach I would like to know why:
|
| *To_Date(To_Char(DateField,'HH24:MI'), 'HH24:MI') : puts '01/07/2004' in
| front of the hour/minute part (the original data is not for '01/07/2004'
| (and is not the date on which I was running the expression), but this is
the
| date given in the all rows resulting from the above expression).
|
| I would have expected the date element to show either today's date (as the
| date is not specified in the To_Date expression) or 1st Jan 1900 (or
| whatever the base date is in Oracle if it differs from the Windows
| 'standard').
|
| Thanks
|
| Paul
|

you must be in europe -- 01/07/2004 is july 1st over there, i'm getting 07/01/2004 for july 1st over here in the colonies

oracle defaults individual date elements when not supplied

year: current
month current
day of month 1st
hour 0
minute 0
second 0

go to http://tahiti.oracle.com for oracle docs -- the SQL manual describes oracle datatypes and functions

++ mcs Received on Thu Jul 22 2004 - 11:19:38 CDT