From my code I know, that a date is spelled yyyy-mm-dd inside an insert statement but in the output of request level logging the statement is logged with the date in the form yyyy/mm/dd.
Have I mismatched any option?
Version is 220.127.116.116
asked 05 Nov '10, 07:53
What API are you using? I ran some tests (using dbisqlc) and I am not seeing the behaviour that you are seeing.
Here is one test that I tried:
Here is the output from the select statement:
What I see in the request level log (rll.txt) is:
For completeness, here is what I see in the console log (console.txt):
Note that the RLL shows that the timestamp strings are passed to the engine as they were entered and the result (from the select) is what is expected - the '2010/2/20' was displayed as '2010-02-20'.
Note also that the timestamp at the beginning of the RLL is fixed to be in 'mmdd hhnnss.sss' format and the timestamp in the console log is fixed to be 'mm/dd hh:nn:ss' format.
So I suspect that the front-end API that you are using (I'm guessing .net or jdbc perhaps?) is changing the timestamp format before sending it to the database server.
FWIW: I am using a debug build 18.104.22.1688 but I do not believe that the build number should matter in this case since I do not know of any changes that have been made that would affect the RLL formatting.
answered 05 Nov '10, 23:56