Database

Calculate Date

Last Updated: May 18, 2016 10:25:46 PM
Created On: 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

Last Updated: August 16, 2015 03:46:45 PM
Created On: August 15, 2015 12:00:00 AM

# case when '' then '' else '' end

Last Updated: August 16, 2015 03:47:09 PM
Created On: August 15, 2015 12:00:00 AM

# cast(() as signed) as ''

/var/www/sequoia_dev/support/Processes/npi/make_NPI_db.sql