Harrison Fisk wrote:
Hi Jay,

On Jan 9, 2009, at 3:31 PM, Jay Pipes wrote:

CURRENT_TIMESTAMP
CURRENT_TIMESTAMP()

I believe that CURRENT_TIMESTAMP is from ANSI.  I think they should remain.

OK.

LOCALTIME
LOCALTIME()
LOCALTIMESTAMP
LOCALTIMESTAMP()

I *think* these were added for Oracle compatibility. I'm fine with removing these.

+1

However, due to Drizzle only supporting UTC, the following functions will be identical to NOW() as well:

UTC_TIMESTAMP()

Seems like a good descriptive name.  My vote is keep it.

OK.

UNIX_TIMESTAMP() (called with no args)

Doesn't this return epoch time and not a datetime?

Yes, you are correct. The difference is the return type (string representation of a datetime versus an int)

Cheers,

jay

_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to