STORE IT AS VARCHAR!!! In the TABLE. You wont be able to store it in
DATE field in your desired format

-----Original Message-----
From: AJAY KUMAR Singh
[mailto:oracledba-ezmlmshield-x28609984.[Email address protected]
Sent: 01 August 2006 14:18
To: LazyDBA Discussion
Subject: Error !!

Gurus,

I need to store the entire value 'TO_DATE('01/01/1900','MM/DD/YYYY')' as
string in the database table but I'm not able to do so. It's converting
the value '01/01/1900' to 'MM/DD/YYYY' format and then it gets stored.
Any help appreciated.

Thanks,
-Ajay
Confidentiality Statement:

This message is intended only for the individual or entity to which it
is addressed. It may contain privileged, confidential information which
is exempt from disclosure under applicable laws. If you are not the
intended recipient, please note that you are strictly prohibited from
disseminating or distributing this information (other than to the
intended recipient) or copying this information. If you have received
this communication in error, please notify us immediately by return
email.


--------
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