To_date('08/09/05','mm/dd/yy')

If the column data type is DATE, then it will return whatever default
date formate is set NLS parameters. The default is 'dd-mon-yy'



-----Original Message-----
From: Kelly Musilu
[mailto:oracledba-ezmlmshield-x54602072.[Email address protected]
Sent: Thursday, September 08, 2005 9:35 AM
To: LazyDBA Discussion
Subject: Question DBAs

Hi all,

How do I, when inserting dates in a table, get the sysdate format no
matter how the date is entered.
example if sysdate is 08-SEP-05 how do I insert 08/09/05.

Thanks
Kelly


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page