Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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.
Thanks
Hi @bexy ,
Glad to know that your issue got resolved. Please continue using Fabric Community on your further queries.
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.
User | Count |
---|---|
23 | |
15 | |
5 | |
5 | |
2 |
User | Count |
---|---|
49 | |
45 | |
17 | |
8 | |
6 |