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
Last activity: Apr 3, 2017, 02:00 PM