slides/time/in-database2.xml
Storing date/time in a database
21/26
Storing date/time in a database
Storing date/time in a database
  • • Goal: Store date exactly 4 months in the future
  • • Store: timestamp and timezone identifier (America/Montreal)
  • • Current date/time: Jun 1st, 13:00 EDT (1338570000)
  • • Future date/time: Oct 1st, 13:00 EDT (1349110800)
  • • Local time for Santiago can also be calculated with the timestamp and its timezone identifier (America/Santiago).
  • • Conclusion: Storing timestamp and timezone identifier allows you to convert to local time