On Fri, 2004-11-05 at 16:48, Allen Landsidel wrote:
> On Fri, 5 Nov 2004 16:31:21 -0500, Goutam Paruchuri
> <gparuchuri@oneil.com> wrote:
> >
> > Iam trying to import data from ms-sql server to postgres. I export the data
> > which has datetime columns in sql server using BCP. I use the following to
> > import back into postgres.
> >
> > copy tablename from 'c:\\bcpdata\\mcfa\\tablename.txt' with delimiter as
> > '\t'
> >
> > I get the following error !!
> > invalid input syntax for type timestamp: ""
> >
> > My input file has the timestamp value like
> >
> > 2004-09-30 11:31:00.000
> >
What about the ".000" on the end? I am not able to enter that format in
a timestamp field in 7.4.5, it is invalid.
--
Robert