Postgres Pro
Downloads
Home   >   mailing lists

Converting POSTGRESQL timestamp to UNIX timestamp - Mailing list pgsql-php

From Richie
Subject Converting POSTGRESQL timestamp to UNIX timestamp
Date
Msg-id Pine.OSF.3.96.1010322172104.28810A-100000@student.cs.ucc.ie
Whole thread Raw
Responses Re: Converting POSTGRESQL timestamp to UNIX timestamp  (Grant <grant@conprojan.com.au>)
Re: Converting POSTGRESQL timestamp to UNIX timestamp  (Grant <grant@conprojan.com.au>)
List pgsql-php
Tree view 
Hi

I have a field of type timestamp in my database but when I retrieve it I
want to convert it to its unix timetamp value because I need to compare 2
tables by their timestamp value.

Any ideas how to convert PostgreSQL timestamp to Unix timestamp???

Thanks

Richie

=========================================================
Richie Duggan
Computer Science IV
University College Cork
Eamil : dugganr@student.cs.ucc.ie   richie_dug@yahoo.com
Homepage : http://student.cs.ucc.ie/01/dugganr/index.html

pgsql-php by date:

Previous
From: "Brent R. Matzelle"
Date:
Subject: Re: php, postgres, ssl
Next
From: Richie
Date:
Subject: Refreshing php page every 5 secs WHILE SAVING INFORMATION