datetime
varchar
CONVERT(DATETIME, 2013/02/20,103)
SET DATEFORMAT dmy SELECT '22/02/2013' SET DATEFORMAT mdy SELECT '03/22/2013' SET DATEFORMAT ymd SELECT '2013/03/22' -- Detault format is "mdy"
CONVERT(DATETIME, '2013/02/20',103)
DECLARE @myDate VARCHAR(10) SET @myDate = '2013/03/20' CONVERT(DATETIME, @myDate,103)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)