Yes, to_char(column_Name,'mm/dd/yyyy') "Column_Identifier",
To convert date datatype (01/JAN/2006) to a string value.
To_date is the reverse.

-----Original Message-----
From: Gaurav Shrivastava
[mailto:oracledba-ezmlmshield-x78879048.[Email address protected]
Sent: Tuesday, August 01, 2006 8:21 AM
To: LazyDBA Discussion
Subject: RE: Error !!

use to_char function in front of the required string!

-----Original Message-----
From: AJAY KUMAR Singh
[mailto:oracledba-ezmlmshield-x28609984.[Email address protected]
Sent: Tuesday, August 01, 2006 9:18 AM
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



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