Do I read this correctly that you are trying to store the string literal


'TO_DATE('01/01/1900','MM/DD/YYYY')'?

If so, do this:

Replace the single quotes around the date format and the date if two(2)
single quotes.

create table datetest(

mydate varchar2(50))

insert into datetest values
('TO_DATE(''01/01/1900'',''MM/DD/YYYY'')');



Commit;

select * from datetest

Output:

MyDate
+-----------------------------------+
| TO_DATE('01/01/1900','MM/DD/YYYY')|
+-----------------------------------+







If I have misinterpreted your problem, please clarify.



Steve

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




Oracle LazyDBA home page