how to subtract 1 minute onAfterUpdate from datevalue?

Scriptcase 9 General
#1

Having issue with getting a date variable to update correctly. On After Update event.
I want the code to subtract one minute from a date.But the macro sc_date only subtracts days as the smallest value.
$new_date = sc_date({itemActiveDate}, “yyyy-mm-dd”, “-”, 1, 0, 0);
// $new_date = sc_date({itemActiveDate}, “yyyy-mm-dd”, “-”, 1, 0, 0); //works for subtracting 1 days

$itemrevisionID = {itemrevisionID}-1;
$update_sql = “update item "
. “set itemInActiveDate = '”.$new_date.”’ "
. “where itemID = {itemID} and itemrevisionID = '”.$itemrevisionID."’ "
;
sc_exec_sql($update_sql);
sc_commit_trans();

#2

$datetime_from = date(“Y-m-d H:i”, strtotime("-1 minutes", strtotime($thestime)));

#3

Ok, I got it.
$itemrevisionID = {itemrevisionID}-1;
$update_sql = “update item set itemInActiveDate = DATEADD(MINUTE,-1,’{itemActiveDate}’) where itemID = {itemID} and itemrevisionID = '”.$itemrevisionID."’ "
;

#4

$datetime_from = date(“Y-m-d H:i”, strtotime("-45 minutes", strtotime($thestime)));