Am Donnerstag, 20. Juli 2006 11:26 schrieb LiveShell:
> I want to convert biginteger and integer data type to timestamp
> data type.
That depends mostly on what kind of meaning you intend to attach to an integer
N. If you want seconds since 1970, you could do
x * interval '1 second' + timestamp '1970-01-01'
For other meanings, adjust as necessary.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/