Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Return minutes as date datatype
Thanks Mark,
I am indeed in the old world.
Odd that month and year are current but day is 1st. I guess there must be some logic to that.
Now that I know what to expect for the date part I can try to figure out some kind of work-around for hiding the date portion.
Thanks
Paul
"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message
news:4JydnS1ertrxdGLdRVn-og_at_comcast.com...
> "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
> |
>
>
>
>
>
![]() |
![]() |