December 2002
Intermediate to advanced
928 pages
85h 29m
English
For a complete list of the format elements you can use when formatting dates in output, see Table D-1. That appendix also contains a variety of examples illustrating the use of the date format elements, as well as a summary of time zone identifiers.
Use the date format elements listed in Appendix D in conjunction with Oracle’s built-in TO_CHAR function to convert date values to character strings. For example:
SQL>SELECT TO_CHAR(SYSDATE, 'dd-Mon-yyyy hh:mi:ss PM')3FROM dual;TO_CHAR(SYSDATE,'DD-MON ----------------------- 13-Dec-1999 09:13:59 PM
When used with the ACCEPT command, a date format string requires the user to enter a date in the format specified.