Timestamp

Started by Enrico Cominiover 25 years ago2 messagesgeneral
Jump to latest
#1Enrico Comini
algobit@algobit.com

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

#2Karel Zak
zakkr@zf.jcu.cz
In reply to: Enrico Comini (#1)
Re: Timestamp

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