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/
