Re: SYSDATE VS $$DBTIME$$ - UPDATE PROBLEM
From: Karl Regel <Karl_Regel_at_p3.f5840.n240.z2.fidonet.org>
Date: 1995/12/08
Message-ID: <MSGID_2=3A240=2F5840.3=40fidonet_bf39921a_at_fidonet.org>#1/1
Date: 1995/12/08
Message-ID: <MSGID_2=3A240=2F5840.3=40fidonet_bf39921a_at_fidonet.org>#1/1
+++ caharper # hooked.net_at_2:240/5889 +++ "SYSDATE VS $$DBTIME$$ - UPDATE PROBLEM" Hi Craig,
c> :item := to_char(sysdate, 'HH:MM:SS');
Sure, 'MM' means MONTH and NOT Minutes !!! Try (sysdate, 'hh:mi:ss') -- as the manual says ! Best luck !
Regards Karl
FIDO : 2:240/5840.3
MAIL : 100666.3450_at_compuserve.com
Received on Fri Dec 08 1995 - 00:00:00 CET