Re: Timestamp - Mailing list pgsql-general

From Karel Zak
Subject Re: Timestamp
Date
Msg-id Pine.LNX.3.96.1001011122743.30162G-100000@ara.zf.jcu.cz
Whole thread Raw
In response to Timestamp  ("Enrico Comini" <algobit@algobit.com>)
List pgsql-general
On Wed, 11 Oct 2000, Enrico Comini wrote:

> date problem with PHP and Postgresql.
>
> I fetch a date $date_ord (timestamp) from Postgresql, then I have
>

 First, look at PHP and PostgreSQL manuals and comperate PG's timestamp
and PHP date() param2 ...!

> date("l, d F, Y",$date_ord)

 You can formatfing date/time output from PG inside SQL query, see the
function to_char()

> But this value is always thursday, 01 January, 1970

 .. sure ...

                    Karel


pgsql-general by date:

Previous
From: "Enrico Comini"
Date:
Subject: Timestamp
Next
From: "Adam Lang"
Date:
Subject: Re: Re: [HACKERS] My new job