Postgres Pro
Downloads
Home   >   mailing lists

Re: datetime - Mailing list pgsql-general

From Pramod R. Bhagwat
Subject Re: datetime
Date
Msg-id 3E0056A7.154C5FF4@ncoretech.com
Whole thread Raw
In response to datetime  ("Pramod R. Bhagwat" <pramod@ncoretech.com>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: 2 gig file limit (yes I know, read anyway ;))
Next
From: Manfred Koizar
Date:
Subject: Re: INDEX suggestion needed