datetime - Mailing list pgsql-general

From Pramod R. Bhagwat
Subject datetime
Date
Msg-id 3E0012A7.E7A336EC@ncoretech.com
Whole thread Raw
List pgsql-general
Hi,
i have a table Test with following fields
Id int
Expires int
The below query works perfectly fine on PostgreSQL version 7.0

select TO_CHAR(TIMESTAMP(datetime(Expires)), 'DD-MM-YYYY HH:MI AM') from
Test;

 But it doesn't work on PostgreSQL version 7.2 On PostgreSQL version 7.2
i get following error
ERROR:  parser: parse error at or near "datetime"
Please inform me what changes i have to make.
Regards,
pramod


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 2 gig file limit (yes I know, read anyway ;))
Next
From: Toby Tremayne
Date:
Subject: return setof record from function with dynamic query