[EMAIL PROTECTED] wrote: > 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?!!
I think it's a bug and we'll fix it in one of the next releases (see http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1123134) Sorry for any inconvenience. Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
