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