WAITFOR DELAY '00:00:.930'; valid in V11, fails in V12

[Breck_Carter]

WAITFOR DELAY '00:00:.930';

V11 result: Execution time: 0.969 seconds

V12 result...

Could not execute statement.
Cannot convert '00:00:.930' to a timestamp
SQLCODE=-157, ODBC 3 State="07006"
Line 1, column 1

[Former Member · Accepted solution]

Breck,

Thanks for reporting this change in behaviour. We made many changes in timestamp parsing to resolve a bunch of other problems and seem to have introduced one or two behaviour changes in the process. This particular problem with the "missing seconds" has been reported and will be fixed in an upcoming EBF.