Viewing 6 posts - 1 through 6 (of 6 total)
Thom A wrote:Have you tried using an unambiguous date format?
'2021-11-01 00:00:00.000'is ambiguous withdatetime. Try'2021-11-01T00:00:00.000'or just'20211101'.Well spotted!
Not being American teaches you quickly that the...
October 24, 2022 at 1:17 pm
i am running it now, will keep you posted once it returns results
October 24, 2022 at 12:52 pm
date_1 has data type as datetime and system type as datetime
October 24, 2022 at 12:51 pm
this is the data I am interrogating, thousands of entried but I have copied one for info:
link_id link_ref network date_1 time_per veh_cls data_source no_of_obs av_jt sum_sq_jt id
4000000013232751B 1727255 8 2021-11-11...
October 24, 2022 at 12:48 pm
Msg 242, Level 16, State 3, Line 8
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
(0 rows...
October 24, 2022 at 12:45 pm
Viewing 6 posts - 1 through 6 (of 6 total)