Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group