Hi,

we are running into trouble setting date values in an MSSQL Database
connected by the current driver 4.0.2.1.

The field types in the table are datetime which should work with any
dates between 1700 and 9999 (aprox.)

Whatever syntax we are providing for those fields we never get the event
processed, because the driver is getting the error that the syntax
provided cn not be converted to java.jdbc.timestamp.

Browsing the forum I found some old articles which stated that the value
provided must be !CTIME - is this still the case?

We did test the following syntaxes - all with no success :-(
yyyymmdd
yyyymmdd hh:mm:ss
yyyy-mm-dd
yyyy-mm-dd hh:mm:ss

Any suggestions?

Regards,

Thorsten


--
tschloesser
------------------------------------------------------------------------
tschloesser's Profile: https://forums.netiq.com/member.php?userid=3232
View this thread: https://forums.netiq.com/showthread.php?t=56335