How to insert a value into a table of datatype datetime2 in Fabric Datawarehouse

[bexy]

When I was trying to insert as 

update table_name

set column_name = '0000-00-00 00:60:00.00'

Getting error as : Conversion failed when converting date and/or time from character string

[bexy]

Thanks

[Anonymous]

Hi @bexy ,

Glad to know that your issue got resolved. Please continue using Fabric Community on your further queries.

[Anonymous · Accepted solution]

Hi @bexy ,

Thanks for using Fabric Community. It looks like there might be ome compatibility issues using 0000-00-00 00:60:00.00

Try use below code -

update [ware_house].[dbo].[table1]
set [created_date] = '0001-01-01 00:59:00.00'

 
Hope this is helpful. Do let me know incase of further queries.