Re: [SQL] convert a bigint into a timestamp

2002-07-25 Thread Richard Huxton
On Thursday 25 Jul 2002 1:48 am, marc sturm wrote: > Hello, > > Does anyone know how to convert a bigint into a date > or timestamp in a SQL query. > Thanks a lot. The problem is that there is no cast from bigint=>interval directly AFAICT, so go via text. richardh=> select extract(epoch from no

[SQL] convert a bigint into a timestamp

2002-07-24 Thread marc sturm
Hello, Does anyone know how to convert a bigint into a date or timestamp in a SQL query. Thanks a lot. Marc __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com ---(end of broadcast)--