Skip to Content
-1
May 31, 2018 at 11:29 AM

Select query with offset based on timestamp

404 Views

Hi All,

In standard table the date and time field are storing in same field like

31.05.2018 16:46:40.. In my requirement i wan to delete the latest records based on time and date..Before conversion routine the value is stored in lv_date1(diff format).

DELETE FROM TABLE WHERE created_by EQ sy-uname and created_at eq lv_date .

Because of conversion routine it is throwing sy-subrc = 4, this is not deleting any records..

Pleas give me suggestion to delete records based on time(greater than time).

Thanks.