On Tuesday 16 March 2004 5:56 pm, Frank Finner wrote:
On Tue, 16 Mar 2004 16:54:18 + Gary Stainburn
[EMAIL PROTECTED] sat down, thought
long and then wrote:
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
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
On Tue, 16 Mar 2004 16:54:18 + Gary Stainburn [EMAIL PROTECTED] sat down, thought
long and then wrote:
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
Gary Stainburn [EMAIL PROTECTED] writes:
How can I insert the integer timestamp in $timestamp into my table?
The clean way is
select 'epoch'::timestamptz + integer * '1 second'::interval;
for instance
regression=# select 'epoch'::timestamptz + 1079459165 * '1 second'::interval;