Hi,
We use the date-time function 'now' with our insert statements to add the
current timestamp.
However, I have just tried it with an UPDATE statement, and it complains -
it makes you use now()
eg
INSERT INTO Metrics
(Kiosk_Id,Form_Id,Copies,Pages,Script_Id,ExecTime) VALUES (-1,1,1,2,1,now)
works, but
UPDATE forms SET Revision_Number = 1, Revision_Date = now,
CycloneFormSetName = 'ki11058219414332' WHERE Id = 1
doesn't,
However
UPDATE forms SET Revision_Number = 1, Revision_Date = now(),
CycloneFormSetName = 'ki11058219414332' WHERE Id = 1
does.
Can anybody explain this?!!
Cheers,
David
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
