Re: datetime - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject Re: datetime
Date
Msg-id 3E001CB8.5040705@mega-bucks.co.jp
Whole thread Raw
In response to datetime  ("Pramod R. Bhagwat" <pramod@ncoretech.com>)
List pgsql-general
Pramod R. Bhagwat wrote:
 >
 > Hi JC,
 > i tried above but it doesn't work i got following error
 > ERROR:  Cannot cast type 'integer' to 'timestamp with time zone'

Oops ... forgot you can't force an int to be a timestamp.

Don't know the answer to your question. But to help you in the long run
how about convertinf your column definition from int to timnestamp (if
it really is a timestamp it should be of that type and not int).

Jc



pgsql-general by date:

Previous
From: Arindam Haldar
Date:
Subject: unsubscribe
Next
From: Mark Kirkwood
Date:
Subject: Re: 2 gig file limit (yes I know, read anyway ;))