sql select from_unixttime with format

9/9/2015 - 6:30 AM

from_unixtime(dateline + '.$time_offset.',"%Y%m")

Cacher is the code snippet organizer for pro developers