SQL SET DATEFORMAT

The SQL SET DATEFORMAT Functions will set the Order of the Date: Month, Year, and Day. This Statement supports formats like dmy, mdy, ymd, ydm, and dym where d = Date, m = month, and y = Year. The basic syntax of the SQL DATEFORMAT is as shown below: SET DATEFORMAT DateFormat_Name SQL SET DATEFORMAT … Read more