advanced code snippet search

Posted By

mafro on 04/01/08


Tagged

mysql timestamp


Versions (?)

MySQL Unix Timestamps

 / Published in: SQL
 

Example of date parsing when you store a unix timestamp as an int in your DB.

Expand | Embed | Plain Text 
  1. SELECT min( FROM_UNIXTIME(timestamp, '%Y') ) AS min_year
  2. FROM calendar_dates

Report this snippet  

You need to login to post a comment.