on 2021 Sep 06 1:39 PM
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
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 KumarYou must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.