TO_CHAR(sysdate,'DD/MM/YY')


-----Original Message-----
From: Kelly Musilu
[mailto:oracledba-ezmlmshield-x54602072.[Email address protected]
Sent: Thursday, September 08, 2005 10:05 PM
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