Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Strange timestamp behaviour |
Fri, Feb 12 2016 6:17 AM | Permanent Link |
Rolf Frei eicom GmbH | I have added some records ot 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. Regards Rolf |
Fri, Feb 12 2016 2:08 PM | Permanent Link |
Rolf Frei eicom GmbH | More infos:
I have now searuch tihe real value which seems to be inthe database and came to this SQL which returns my expected result: SELECT * FROM MyTable WHERE newdate = TIMESTAMP '2016-02-12 00:17:00.289' So I wonder why EDBManager shows '00:17' while the correct values should be '00:17:00.289'? Regards Rolf |
Mon, Feb 15 2016 12:44 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Rolf,
<< 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? >> That time is 17 minutes past midnight. Can you send me the database catalog and table files for the table that you're seeing this in ? It could just be a formatting issue with the EDB Manager, but it may be something deeper in the engine. Thanks, Tim Young Elevate Software www.elevatesoft.com |
Tue, Feb 16 2016 7:35 AM | Permanent Link |
Rolf Frei eicom GmbH | Tim
Please see my other message in this thread too. Yes it seems to be a EDB formating issues as I can see the correct value in my own application. The correct value of the field is 00:17:00.289. EDBM does show this as 00:17. Regards Rolf "Tim Young [Elevate Software]" schrieb im Newsbeitrag news:8E6DC8EF-36D1-413A-A55C-C7D5BE406F83@news.elevatesoft.com... Rolf, << 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? >> That time is 17 minutes past midnight. Can you send me the database catalog and table files for the table that you're seeing this in ? It could just be a formatting issue with the EDB Manager, but it may be something deeper in the engine. Thanks, Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Monday, May 6, 2024 at 12:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |