Re: [GENERAL] Inserting a timestamp in a "timestamp" column.

I normally use (for php) something like date('Y-m-d H:i:s', time()) to get a string version that Postgres will accept. On Sep 14, 2007, at 3:23 PM, rihad wrote: 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

[GENERAL] Inserting a timestamp in a "timestamp" column.

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. ---