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 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.
---------------------------(end of
broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
Erik Jones
Software Developer | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
