Hello Mark, >> I’ve got a database from a customer with a timestamp value >> 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)?
Apparently, by using software created by me. Which 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!
