Re: Importing from Access 2000?

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Bjørn T Johansen <btj(at)havleik(dot)no>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Importing from Access 2000?
Date: 2003-04-29 13:46:29
Message-ID: 1051623988.9017.386.camel@linda.lfix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2003-04-29 at 14:31, Bjørn T Johansen wrote:
> Well, they are timestamps but they are just using the time part without
> the date part in the old access db.
> So I am not sure which type it should be the postgresql db, so any
> suggestions are appreciated...

There is a TIME data type.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"And he said to them all, If any man will come after
me, let him deny himself, and take up his cross daily,
and follow me." Luke 9:23

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-04-29 13:56:42 Re: timestamps and dates
Previous Message Sergio Pili 2003-04-29 13:45:19 Re: Error: No one parent tuple was found