Icon View Incident Report

Minor Minor
Reported By: Rolf Frei
Reported On: 2/12/2016
For: Version 2.21 Build 1
# 4360 Time Values with Zero Seconds and Non-Zero Milliseconds Converted Incorrectly to String

I have added some records to a table with the actual system time. Now it is strange as there are values in the field which look strange in EDBManager:

Normaly timestamp fields would show as "2016-02-12 01:50:45.978" but in my case some of them show this "2016-02-12 00:17". What is this time exactly? 17 seconds after midnight or 17 minutes or what?

The worst is that I'm not able to select for this fields at all in
EDBManger:
SELECT * FROM MyTable WHERE MyTimeStam = TIMESTAMP '2016-02-12 00:17'

This query brings no records back?! Also '00:17:00.000' or '00:00:17.000'
gives no results.

Is it not possible that EDBManager shows the time part of a TIMESTAMP as
'00:00:00.000' all the time as '00:17:00.000' or '00:00:17.000' whatever the
above value exactly means.


Comments Comments
The problem was that EDB was looking at the seconds and not outputting the milliseconds if the seconds were zero.


Resolution Resolution
Fixed Problem on 2/21/2016 in version 2.22 build 1


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image