By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,426 Members | 2,928 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,426 IT Pros & Developers. It's quick & easy.

Invalid Input Syntax for Type date

P: 1
I am trying to import a text file into a postgres table and I get the following error message:

Invalid input syntax for type date: field name

The date format is yyyy-mm-dd
So the text file has 1999-02-22 as an example

I also tried changing the date format but the error was still raised

Please help!
Nov 19 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 700
Writing @1251ila
you mean using
Expand|Select|Wrap|Line Numbers
  1. copy
command?
Is any data put into table when you do the import or no?
When you say about date format, did you check it in the database using
Expand|Select|Wrap|Line Numbers
  1. show datestyle
  2.  
command?
Nov 23 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.