Sample Header Ad - 728x90

How to set datetime2 to mandate?

0 votes
1 answer
2156 views
I want to create a SQL Script to clean datetime2 field and set it up to datetime2 begin '1-1-0001 12:00:00'. How to set GETDATE() to '1-1-0001 12:00:00' instead of using convert function ? UPDATE XYZTable SET ReferralDate = CONVERT(datetime2, '1/1/0001 09:00')
Asked by NinjaDeveloper (245 rep)
Mar 21, 2017, 06:42 PM
Last activity: Apr 3, 2017, 02:00 PM