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

Re: timestamp

From: "Mitch Vincent" <mitch(at)venux(dot)net>
To: "Nico D" <nico(at)mclink(dot)it>, <pgsql-php(at)postgresql(dot)org>
Subject: Re: timestamp
Date: 2000-12-04 01:39:42
Message-ID: 003901c05d93$13479d50$0200000a@windows (view raw or flat)
Thread:
Lists: pgsql-php
http://www.postgresql.org/devel-corner/docs/postgres/datetime-functions.htm

More specifically :

date_part('epoch',<timestamp>)

You can pass that to PHP's date() function and format the time to your
liking.

-Mitch
----- Original Message -----
From: "Nico D" <nico(at)mclink(dot)it>
To: <pgsql-php(at)postgresql(dot)org>
Sent: Sunday, December 03, 2000 1:53 AM
Subject: [PHP] timestamp


> Is there any function that converts the internal PG timestamp format into
unix
> timestamp format?
>
> Or viceversa, is there a PHP function that formats properly
> the PG timestamp according to the setlocale setting?
>
> I'm trying to get the CPU-wasteless time conversion.
> (I'm using PG 7.0.2)
>
> Thanks
> Nico
>
>
>


In response to

  • timestamp at 2000-12-03 09:53:54 from Nico D

pgsql-php by date

Next:From: Adam LangDate: 2000-12-04 13:54:18
Subject: Re: timestamp
Previous:From: Nico DDate: 2000-12-03 09:53:54
Subject: timestamp

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