This week we talk about time formats and time zones in MySQL - including how changing the system time changes TIMESTAMP values but not DATETIME values. We also talk about how to handle and store microseconds in MySQL.
The UTC_TIMESTAMP() function:
UTC_TIMESTAMP() is replication-safe and based on CURRENT_TIMESTAMP. Try this example for yourself:
mysql> SELECT UTC_TIMESTAMP(),SLEEP(5),UTC_TIMESTAMP()\G
Sarah will be at the Velocity Conference, Tuesday June 14th through Thursday June 16th in Santa Clara CA, speaking about the many layers of caching in the modern web stack. Get 20% off registration by using discount code FRIEND
We will both be at Open Source Bridge from Tuesday, June 21st – through Friday, June 24th in Portland, Oregon.
Sheeri will be at Kscope 11, an Oracle Developer Conference, from Sunday, June 26th through Thursday, June 30th in Long Beach, California.
We will both be at OSCon 2011 from Monday, July 25th through Friday, July 29th in Portland, Oregon. Get 20% off registration using the discount code os11com.
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369