OurSQL Episode 46: It's About Time

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.

From the MySQL manual:
date and time types
TIMESTAMP properties and how it is stored in UTC transparently in the database
ALLOW_INVALID_DATES sql_mode
--timezone option
SYSDATE vs. NOW()

Ear Candy:
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

Sheeri will be speaking at Percona Live in New York City on Thursday, May 26th and even though space is running out, there is still a discount code for $50 off using this link.

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.

Feedback
Facebook group
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369

Trackback URL for this post:

http://technocation.org/trackback/1116