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
