Re: to_char(...) documentation

In general - to_char(date,format)
so to_char(datefield,'MM-DD-YYYY') will produce a char field like '12-21-1997'

The format list in extensive, but somewhat logical :( see the Oracle Language guide for details.

mmddyy - 122197
dd-mon-yyyy - 12-DEC-1997
etc

Hope it helps,
John Greco
Oracle DBA
Reply to john.greco_at_dot.state.mn.us

"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