Re: Time?
From: Andrew Simkovsky <asimkovsky_at_email.msn.com>
Date: Fri, 13 Apr 2001 16:33:44 -0400
Message-ID: <uuFK4fFxAHA.287_at_cpmsnbbsa09>
Date: Fri, 13 Apr 2001 16:33:44 -0400
Message-ID: <uuFK4fFxAHA.287_at_cpmsnbbsa09>
Oracle's DATE datatype stores all information about date and time built in. This includes date, numeric month, character month, year, weekday, week of the year, century, hour (12 hr with am/pm & 24hr), minutes, and seconds.
"Sarah" <sra_at_optushome.com.au> wrote in message
news:wOuB6.46939$Xx3.261684_at_news1.eburwd1.vic.optushome.com.au...
> Hi there
>
> Just wondering if anyone can tell me how to specify a Time datatype in
> oracle (as the "time" datatype doesn't work like it would in something
like
> MySQL)?
>
> Not sure if this makes a whole heap of sense, but hopefully someone will
> know what i'm talking about :-)
>
> Cheers,
> Sarah.
>
>
Received on Fri Apr 13 2001 - 22:33:44 CEST