Converting POSTGRESQL timestamp to UNIX timestamp

From: Richie <dugganr(at)student(dot)cs(dot)ucc(dot)ie>
To: pgsql-php(at)postgresql(dot)org
Subject: Converting POSTGRESQL timestamp to UNIX timestamp
Date: 2001-03-22 17:23:02
Message-ID: Pine.OSF.3.96.1010322172104.28810A-100000@student.cs.ucc.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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(at)student(dot)cs(dot)ucc(dot)ie richie_dug(at)yahoo(dot)com
Homepage : http://student.cs.ucc.ie/01/dugganr/index.html

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Richie 2001-03-22 18:29:18 Refreshing php page every 5 secs WHILE SAVING INFORMATION
Previous Message Brent R. Matzelle 2001-03-22 16:25:26 Re: php, postgres, ssl