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: (view raw, whole thread or download thread mbox)
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     


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-2017 The PostgreSQL Global Development Group