Hi
Use to_date function
To_date('08/09/05','DD/MM/YY')
Thanks
Saqib

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





************** E-mail Disclaimer **************
This e-mail message is confidential and for use by the addressee only. If you are not the intended addressee, please reply to the sender and then delete the message from your computer.

Please note that any views or opinions presented in this e-mail are those of the author and do not necessarily represent the views or opinions of The Benenden Healthcare Society Limited.

You should check this e-mail and any attachments for the presence of viruses. The Benenden Healthcare Society Limited accepts no liability for any damages caused by any virus transmitted by this e-mail or its attachments.

The Benenden Healthcare Society Limited is an incorporated friendly society, registered under the Friendly Societies Act 1992, registered number 480F. The Society’s contractual business (the provision of tuberculosis benefit) is authorised by the FSA. The remainder of The Society’s business is undertaken on a discretionary basis. The Society is subject to FSA requirement for prudential management.

Registered Office Address: The Benenden Healthcare Society Limited,
Holgate Park Drive, York. YO26 4GG.
Tel: 0870 7545 700 Fax: 0870 7545 822
www.benenden.org.uk

Oracle LazyDBA home page