Hi,
instead of NOW, try the followings:
DATE for Date datatype
TIME for Time datatype
TIMESTAMP for Timestamp datatype
Yves Trudeau
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Klaus Dicks
Sent: 19 novembre, 2002 03:33
To: [EMAIL PROTECTED]
Subject: strange behavior with NOW
hello,
i'm using sapdb 7.3.0. there is a strange behavior with the keyword now.
in statement 'INSERT INTO update_state (begin_time, section, comment) VALUES
(NOW, 'somesection', 'somecomment')'
the current datetime is insered in the table.
statement 'UPDATE update_state SET begin_time = NOW, state = 'COMPLETE'
WHERE id = 1' returns with an error 'missing delimiter'.
the statement 'UPDATE update_state SET begin_time = NOW(), state =
'COMPLETE' WHERE id = 1' does the correct update.
can anybody tell me why i can't use NOW in update statements?
thank you
--
freundliche Gr�sse
Klaus Dicks
Organisationsprogrammierer
--
SHD Datentechnik GmbH, Bereich MHS, Rennweg 60, 56626 Andernach
Telefon (0 26 32) 2 95-685 Fax (0 26 32) 2 95-488
mailto:[EMAIL PROTECTED] http://www.shd.de
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
