Re: [SQL] Conversion

Mon, 12 Aug 2002 20:09:48 -0700

Is the int4 a UNIX epoch? ie. seconds since 1970?
 
If so, then this will generally work:
 
SELECT CAST(int4field AS abstime);
 
or
 
SELECT int4field::abstime;
 
Chris
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lonh SENG
Sent: Tuesday, 13 August 2002 11:14 AM
To: [EMAIL PROTECTED]
Subject: [SQL] Conversion

Hi all,
 
        How can I convert from int4 to date time?
 
 
Regards,
   
    Lonh

Reply via email to