Shilpa, use the date(<text string>) function to get dates, instead of
to_date(which is actually TIMESTAMP_FORMAT() function).Eg:

-------------------------
bash-2.05a$ db2 "values date('05-11-2005')"
1
----------
05/11/2005
1 record(s) selected.
-------------------------

Steven, I couldn't see any function that accepts string month names. Looks
like you would have to convert it to an acceptable format (yyyyxxddhhmmss,
2005-07-27-17.54.33.000000) before feeding the string to timestamp()
function.

Thanks

Naveen
Disclaimer:

This e-mail, and any files transmitted with it are confidential to Marlabs Inc. and intended solely for the use of the individual or entity to whom it is addressed. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

DB2 & UDB email list listserv db2-l LazyDBA home page