Jacob DeHart

Scroll to Top

How to get a signed unix timestamp from a MySQL datetime field that is pre Unix Epoch compatible

If you’ve ever used MySQL to store dates with datetime and wanted to use UNIX_TIMESTAMP() on dates from before the Unix Epoch, here is a little bit of SQL magic for you.

Code

June 13, 2012
comments

Share
http://tmblr.co/Z2ZrbyNJwmKA
SQLMySQLUNIX_TIMESTAMPEpoch

COMMENTS

< Previous post Next post >

 

Theme by Pixel Union

  • Profile
  • Pages
  • Twitter
  • About me

    Founder of Picturelife and previously Threadless. I live in Key West and Chicago with my wife Mischa.

  • Connect with me

    • Twitter
    • Facebook
    • Flickr
    • Last.fm
    • Skype
    • Svpply
    • Github
  • RSS
  • Archive
  • Ask me anything
  • Submit

@jacobdehart

Follow @jacobdehart