datetime

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

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