MII Query current_timestamp

[reini]

Hello guys,

is it possible with a mii query that i substract 1 day from the current_timestamp

ex.

where activity_log.date_time > ....-1

thanks for help

Reinhard

[ajit3204 · Accepted solution]

Hi Reinhard,

Use below query to sustract days. First you have to convert the date string to timestamp and then you can use the add_days.

select ADD_DAYS(TO_TIMESTAMP (ACTIVITY_LOG.DATE_TIME, 'YYYY-MM-DD HH24:MI:SS') ,-1) from ACTIVITY_LOG Regards,Ajit Kumar

[reini · Accepted solution]

thank you Ajit, that was what i was looking for!

[sergiy_katerinich]

Seen these functions? Like dateadddays(startDate,addDays) etc.

https://help.sap.com/viewer/d70c3ac3566b41dd896cd7cecc94e14a/15.4/en-US/4cc8a0fc8e9b60c5e10000000a15...