Timestamp types should not include "WITH TIMEZONE". Redshift uses "GETDATE()" not NOW()