When I try and insert the date into a datetime field I get.
I want to display the date as dd/mm/yyyy
, CONVERT(VARCHAR,GETDATE(),101) AS EXTRACTION_DATE
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
i've even tried --declare @date as datetime
--SET DATEFORMAT dmy;