Re: Year, Month, Day, Hour & Minute from Timestamp

From: Austin Durbin <adurbin_at_cox.net>
Date: Sun, 8 Jun 2003 10:32:09 -0700
Message-ID: <qWJEa.65695$MJ5.46102_at_fed1read03>


Take a look at the TO_CHAR function which is fully documented in the Oracle SQL Reference manual. Alternatively, you can search Google for TO_CHAR which will yield several examples.

As to the other response your received, just ignore it. There will always be children who feel a certain glee in wasting everyone's time and bandwidth with their clever responses.

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:4vHEa.65563$MJ5.30267_at_fed1read03...
> John Luongs wrote:
> > Are there function to retrieve the year, month, day, hour and minute
> > from a timestamp datatype? Thanks.
> >
>
> Yes.
>
Received on Sun Jun 08 2003 - 19:32:09 CEST

Original text of this message