I like to rip on MySQL as much as the next guy, but the article is incorrect abo... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

lysol on July 4, 2011 | parent | context | favorite | on: What every programmer should know about time

I like to rip on MySQL as much as the next guy, but the article is incorrect about MySQL DATETIMEs:

DATETIME: Eight bytes: A four-byte integer packed as YYYY×10000 + MM×100 + DD A four-byte integer packed as HH×10000 + MM×100 + SS

Storing UNIX time as an integer would be silly, considering:

TIMESTAMP: A four-byte integer representing seconds UTC since the epoch ('1970-01-01 00:00:00' UTC)

troels on July 4, 2011 [–]

MySql's datetime fields are not timezone aware. If one client has set one timezone and inserts a value in a datetime field and another client has a different timezone, the value will not be converted.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact