Hi,
While loading data into a table using the following command:
    copy [table] from [file]
I found that the format for datetime field should always be like "Thu Sep 06 
18:36:40 2001 IST" format. But actually I want to upload data from a 
csv/text file where datetime field is in "2001-09-06 18:36:40.000" - is 
there any way to specify the datetime format? By the way I am using postgres 
6.5.3 version.

Warm Regards

Amit



_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


--
To unsubscribe, send mail to [EMAIL PROTECTED] with the body
"unsubscribe ilug-cal" and an empty subject line.
FAQ: http://www.ilug-cal.org/help/faq_list.html

Reply via email to