| Subject | Re: [firebird-support] Timestamp value with time part of "24:00:00.0000" |
|---|---|
| Author | Martijn Tonies (Upscene Productions) |
| Post date | 2014-01-13T18:56:03Z |
Hello Mark,
kinda surprises me!
The client used our test data generator in Database Workbench
and each new value should be 15 minutes later than the previous
row, he was using Firebird 2.1 (on re-reading his message) and
-some- values were incorrect.
This query returns the value as 24:00:
select
T_DATACZAS, cast(T_DATACZAS as char(24))
from
BATCH_DOBOWE where D_IDPOMIARU=97
The results:
DATACZAS CAST
2014-01-04 2014-01-03 24:00:00.0000
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
>> I’ve got a database from a customer with a timestamp valueApparently, by using software created by me. Which
>> with a time part of "24:00:00.0000".
>> It this supposed to be possible on Firebird 2.5.2?
>> isql reports an error when selecting the value:
>> “ value exceeds the range for valid timestamps “
>> Any clue?
>
>How was the value inserted (or updated)?
kinda surprises me!
The client used our test data generator in Database Workbench
and each new value should be 15 minutes later than the previous
row, he was using Firebird 2.1 (on re-reading his message) and
-some- values were incorrect.
This query returns the value as 24:00:
select
T_DATACZAS, cast(T_DATACZAS as char(24))
from
BATCH_DOBOWE where D_IDPOMIARU=97
The results:
DATACZAS CAST
2014-01-04 2014-01-03 24:00:00.0000
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!