Tom Lane writes:
> Try
>
> mycol timestamp default now()
> or
> mycol timestamp default current_timestamp
>
> (the latter is actually a function call, even though the SQL standard
> says it has to be spelled without any parentheses)
And both of these return start time of the current transaction, yes?
Is it the case that there is no SQL-standard way to get the current
time? I know Postgresql has timeofday(), but it's not standard (plus
it's weird that it returns a text string).
- John D. Burger
MITRE