Re: to_char(...) documentation

From: Robert Prendin <rprendin_at_magi.com>
Date: 1998/02/13
Message-ID: <34e4d9b3.424053827@news.istar.ca>#1/1

You may also want to consider time which oracle stores as part of the date... again there are variations on the formats so you will need to check the docs..

example
  1* select to_char(sysdate,'MM-DD-YYYY,hh24:ss:mi') from dual SQL> / TO_CHAR(SYSDATE,'MM

---

02-13-1998,18:07:47

SQL> ed
Wrote file afiedt.buf

  1* select to_char(sysdate,'MM-DD-YYYY,hh:ss:mi') from dual SQL> / TO_CHAR(SYSDATE,'MM

---

02-13-1998,06:28:47

to_char(sydate,'dd-mm-yyyy, hh24:si:mm') from dual; "Mike" <makonnen_at_vt.edu> wrote:

>Hello,
>
>I was wondering if anyone could provide me with documentation for the
>to_char() function in an Oracle database. I am trying to do a pass-through
>Query and I need to handle dates. Thanks.
>
>
>Mike.
>
>
Received on Fri Feb 13 1998 - 00:00:00 CST