Skip site navigation (1) Skip section navigation (2)

UNIX timestamps

From: Eduardo Vázquez Rodríguez <evazquez(at)insys-corp(dot)com(dot)mx>
To: "Postgres (pgsql-novice(at)postgresql(dot)org)" <pgsql-novice(at)postgresql(dot)org>
Subject: UNIX timestamps
Date: 2004-07-28 23:38:02
Message-ID: 59B41C14544D314889E6FA384A307A92420F68@osiris.insys-corp.com.mx (view raw or flat)
Thread:
Lists: pgsql-novice
Hi everyone out there using Postgres

Is there a data type or function in Postgres to handle UNIX timestamps? 

I have to handle datea in unix timestamp format like this 1079092862.453 and
I would like to be inserted in human readable way

Any suggestions are welcome

Thanks in advanced

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2004-07-29 00:34:26
Subject: Re: PQfnumber and duplicate column names....
Previous:From: Ralf HasemannDate: 2004-07-28 22:17:41
Subject: PQfnumber and duplicate column names....

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group