Hi,
I have a table with a varchar field holding values like
Tue Mar 16 09:54:36 EST 2004.

I need to convert this to date format.Can someone help me with the query.