Forum OpenACS Development: Re: current_timestamp = ('now'::text)::timestamp(6) with time zone

Collapse
5: Re: current_timestamp = ('now'::text)::timestamp(6) with time zone (response to 1)
Posted by Don Baccus on 07/18/03 11:47 PM
It's part of the standard, yes, and also once upon a time "now()" in some contexts was only executed once and the value cached, not sure if that's true or not with recent versions of PostgreSQL.

Oracle 9i, at least, also has the timestamp stuff from SQL 92 and eventually I'm hopeful we can use the standard syntax for both RDBMSs (even if other differences mean we can't truly share table definition code, drat)