Postgres Pro
Downloads
Home   >   mailing lists

Convert from unixtime? - Mailing list pgsql-novice

From Forjan Tamas
Subject Convert from unixtime?
Date
Msg-id Pine.LNX.4.33L2.0303192003370.1695-100000@pitr.2fkft.com
Whole thread Raw
Responses Re: Convert from unixtime?
List pgsql-novice
Tree view 
Greetings.

I have some data files that I need to put into a database. My problem is
that all date fields are in unix time format (seconds since 1970.01.01
0:00). What I would like to find is a function that could be used in
INSERT commands to convert such data into a date format understandable to
Postgres. Any ideas?

Thank you very much, (please cc: me directly when answering)

--
Tamas Forjan
tech support
2F 2000 Kft.

pgsql-novice by date:

Previous
From: Fred Soustra
Date:
Subject: Problems when deleting data.
Next
From: "Richard Curtis"
Date:
Subject: Re: Completely stuck - cannot get pgcrypto to work.