Postgres Pro
Downloads
Home   >   mailing lists

Re: Conversion - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Re: Conversion
Date
Msg-id GNELIHDDFBOCMGBFGEFOKEKHCDAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Conversion  ("Lonh SENG" <slonh@camgsm.com.kh>)
Responses Re: Conversion  ("Alexander M. Pravking" <fduch@antar.bryansk.ru>)
List pgsql-sql
Tree view
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: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Lonh SENG
Sent: Tuesday, 13 August 2002 11:14 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] Conversion

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

pgsql-sql by date:

Previous
From: "Lonh SENG"
Date:
Subject: Conversion
Next
From: "Wei Weng"
Date:
Subject: 答复: [SQL] Is this valid?