cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

DATETIME function changed in 17.0.10.5745

Former Member
1,908

Prior to upgrade function DATETIME( ) could read both string time formats '1998-09-09 12:12:12.000' and '12:12:12.000 1998-09-09' After update error occurs: SQL statement failed: (-157) Cannot convert '10:06:33.0 2019/03/29' to timestamp. Changing timestamp_format (or sr_timestamp_format for replications) to 'HH:NN:SS.SSS DD-MM-YYYY' did not help. Do anyone encountered such issue?

Accepted Solutions (0)

Answers (1)

Answers (1)

jack_schueler
Product and Topic Expert
Product and Topic Expert

I have confirmed this as a regression. The fix will appear in a future update. Additional test cases have been added for time before date.