Database
Calculate Date
Last Updated: May 18, 2016 10:25:46 PM
Created: August 15, 2015 12:00:00 AM
date_format(from_unixtime(time_stamp), '%m-%d-%Y') as hitdate
Subtract 1 day
date_format(date_sub(from_unixtime(time_stamp), interval 1 day), '%m-%d-%Y') as hitdate
Add 1 day
date_format(date_add(from_unixtime(time_stamp), interval 1 day), '%m-%d-%Y') as hitdate
MySQL Case
Last Updated: August 16, 2015 03:46:45 PM
Created: August 15, 2015 12:00:00 AM
# case when '' then '' else '' end
MySQL Cast
Last Updated: August 16, 2015 03:47:09 PM
Created: August 15, 2015 12:00:00 AM
/var/www/sequoia_dev/support/Processes/npi/make_NPI_db.sql