On Wed, 21 Mar 2001 13:18:40 John Diamond wrote:
> try
> to_char(foo,'DD-MON-YYYY HH24:MI:SS')
> John
alternatively try
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MON-DD HH24:MI:SS'
if you want all dates to be like that.
Stick SET NLS_DATE_FORMAT = 'YYYY-MON-DD HH24:MI:SS' in init.ora if you
want it to always be that way.
You may have to mess about with column widths as well if you're using
sqlplus (e.g. SET DATEWIDTH=20 (iirc)).
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
