Inserting a timestamp in a "timestamp" column.

From: rihad <rihad(at)mail(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Inserting a timestamp in a "timestamp" column.
Date: 2007-09-14 20:23:47
Message-ID: 46EAEDD3.3090407@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I have a column declared as "timestamp without time zone" that I vainly
want to insert a raw timestamp into (i.e. in the format returned by
Perl's or PHP's time()). I know of SQL NOW(), but I want to insert a
"cooked" timestamp from the outside most efficiently. How?

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2007-09-14 20:32:36 Re: plpgsql trigger original query
Previous Message Oleg Bartunov 2007-09-14 20:00:55 Re: tsearch2 and parsing host strings