Обсуждение: 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.

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@myemma.com
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