Timestamp quickies
To get the current timestamp on your linux machine (oddly has some problem on my customized zsh shell. works fine on bash)
date +%s
To convert timestamp to date format on your linux machine
date -d @
Date to timestamp is
date -d “Dec 21, 2011 22:00:01” +%s
and for heaven’s sake when you are using UNIX_TIMESTAMP() function in mysql, please take care about your TZ difference between your OS and mysql.