select * from E_EVNT_SMRY_ELM where SAM>0 and "E_EVNT_SMRY_ELM"."MOD_DATE_TIME" BETWEEN {ts '2020-11-01 00:00:01'} AND {ts '2020-11-07 23:59:59'}
UPDATE E_EVNT_SMRY_ELM SET TimestampColumn = ADDDATE(d, -2, GETDATE()), OtherTimestampColumn = ADDDATE(d, -8, GETDATE()) WHERE ...
SELECT * FROM E_EVNT_SMRY_ELM WHERE SAM > 0 And MOD_DATE_TIME > _add_days({current_date}, -8) And MOD_DATE_TIME < _add_days({current_date}, -1)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)