Re: Timestamp

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Enrico Comini <algobit(at)algobit(dot)com>
Cc: ML-Postrges-general <Pgsql-General(at)Postgresql(dot)org>
Subject: Re: Timestamp
Date: 2000-10-11 10:32:37
Message-ID: Pine.LNX.3.96.1001011122743.30162G-100000@ara.zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • Timestamp at 2000-10-11 10:22:54 from Enrico Comini

Browse pgsql-general by date

  From Date Subject
Next Message Adam Lang 2000-10-11 12:54:52 Re: Re: [HACKERS] My new job
Previous Message Enrico Comini 2000-10-11 10:22:54 Timestamp