SELECT lastModifiedDate,DateFormat(lastModifiedDate,'dd.mm.yyyy hh.nn.ss.ssssss') as dtFormatted FROM StatData WHERE DateFormat(lastModifiedDate,'hh') = '00'
Gives the result:
What's with that?
mvh Ove B-)
asked 14 Feb '14, 02:35
Ah, I should have guessed, or at least tried isql...
We are using a rather old jconn4.jar, dated 27.01.2010, running against a dbsrv12 GA 12 0 1 3967 linux 2013/09/04 15:54:03 posix 64 production. Will try a newer driver and let you know.
answered 16 Feb '14, 05:19