Re: datetime

From: "Pramod R(dot) Bhagwat" <pramod(at)ncoretech(dot)com>
To: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: datetime
Date: 2002-12-18 11:06:15
Message-ID: 3E0056A7.154C5FF4@ncoretech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> try:
>
> select TO_CHAR(Expires::timestamp, 'DD-MM-YYYY HH:MI AM') from Test;
>

Hi JC,
i changed previous query to the following
select TO_CHAR(datetime(expires), 'DD-MM-YYYY HH:MI AM') from Test;
it works fine.
Regards,
pramod

In response to

  • datetime at 2002-12-18 06:16:07 from Pramod R. Bhagwat

Browse pgsql-general by date

  From Date Subject
Next Message Ken Guest 2002-12-18 11:13:50 converting string value to integer
Previous Message Manfred Koizar 2002-12-18 11:00:55 Re: INDEX suggestion needed