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

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

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

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