Fabric lakehouse table: try_convert not working

[cw88]

Hi, 

i try to use try_convert to convert varchar to date. The column includes some underscores:

When i use the try_convert, i get a conversion error:

In my opinion, this should not happen, or am I missing something?

Thanks!

[rocketporg]

I've got the same problem with a script of mine, using CONVERT. This feels like a bug, but Fabric is still in preview so some of this is to be expected...

But yes, there seems to be an issue here. Interestingly if you take the SQL code and hard code the date as a string and run it then it works fine (see below), just seems to be when doing it with a column from a table...

Works fine:-

SELECT TRY_CONVERT(DATE, '2023-03-01')

This script below however, you get the error message. Even if every row has value '2023-03-01':-

SELECT TRY_CONVERT(DATE, SomeField) FROM SomeTable

[cw88]

Hi @rocketporg ,

thanks, i can reproduce this behavour. I opened a bug ticket.