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/ ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly