Re: Conversion

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Lonh SENG" <slonh(at)camgsm(dot)com(dot)kh>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Conversion
Date: 2002-08-13 03:32:25
Message-ID: GNELIHDDFBOCMGBFGEFOKEKHCDAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf Of Lonh SENG
Sent: Tuesday, 13 August 2002 11:14 AM
To: pgsql-sql(at)postgresql(dot)org
Subject: [SQL] Conversion

Hi all,

How can I convert from int4 to date time?

Regards,

Lonh

In response to

  • Conversion at 2002-08-13 03:14:19 from Lonh SENG

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Wei Weng 2002-08-13 03:52:05 答复: [SQL] Is this valid?
Previous Message Lonh SENG 2002-08-13 03:14:19 Conversion