Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > postgresql > answers

Invalid Input Syntax for Type date

Newbie
  
Join Date: Nov 2008
Posts: 1
#1: Nov 19 '08
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!

Moderator
  
Join Date: Dec 2006
Location: Europe
Posts: 293
#2: Nov 23 '08

re: Invalid Input Syntax for Type date

Writing
Quote:

Originally Posted by 1251ila View Post

I am trying to import a text file into a postgres table

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?
Reply

« previous question | next question »

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,510 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved