Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Return minutes as date datatype

Re: Return minutes as date datatype

From: Paul <pd_oflaherty_at_nospam.hotmail.com>
Date: Thu, 22 Jul 2004 18:22:23 +0100
Message-ID: <T8ednbDfSJhIamLdRVn-ow@brightview.com>


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

>

> 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 - 12:22:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US