current_timestamp in target_sql
Posted: Mon May 12, 2008 11:20 pm
Target group specifications are saved in the dyn_target_tbl table. When you follow the instructions in the OpenEMM documentation, section 5.3.2 Date Functions, regarding current_timestamp, the value OpenEMM puts into the target_sql column is invalid SQL and does not work.
The work around is to manually update the dyn_target_tbl table and change the target_sql value as follows.
wrong: date_format(cust.created, '%Y%m%d') ='current_timestamp-1'
right: date_format(cust.created, '%Y%m%d') = date_format(current_timestamp, '%Y%m%d')-1
The work around is to manually update the dyn_target_tbl table and change the target_sql value as follows.
wrong: date_format(cust.created, '%Y%m%d') ='current_timestamp-1'
right: date_format(cust.created, '%Y%m%d') = date_format(current_timestamp, '%Y%m%d')-1
)!