Re: [SQL] CURRENT_TIMESTAMP

Bruce,

> If we change CURRENT_TIMESTAMP to statement time, I don't think we need
> now(""), but if we don't change it, I think we do --- somehow we should
> allow users to access statement time.

I'd argue that we need the 3 kinds of now() regardless, just to limit user 
confusion.   If we set things up as:

now() = transaction time
current_timestamp = statement time
timeofday() = exact time

That does give users access to all 3 timestamps, but using a competely 
non-intuitive nomenclature.  It's likely that the three types of now() would 
just be pointers to other time functions, but would provide nomenative 
clarity.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco