Thread: Timestamp

date problem with PHP and Postgresql.

I fetch a date $date_ord (timestamp) from Postgresql, then I have

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

But this value is always thursday, 01 January, 1970

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