working with unix timestamp

From: Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: working with unix timestamp
Date: 2004-03-16 16:54:18
Message-ID: 200403161654.18049.gary.stainburn@ringways.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi folks.

I've got a last_updated field on my stock records of type timestamp.

This last_updated field I get using the perl code:

my $timestamp=(stat "$localcsv/VehicleStock.$data_suffix")[10];

How can I insert the integer timestamp in $timestamp into my table?
--
Gary Stainburn

This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-03-16 17:52:26 Re: working with unix timestamp
Previous Message Luis P Caamano 2004-03-16 16:33:12 Re: Can statement_timeout emulated NOWAIT?