Retrieve DATE in various format through SQL Query

Below query is used to retrieve DATE in required format through SQL Query.

'SELECT CONVERT(VARCHAR(100),FieldName, 101) AS Sample_date FROM tableName'

Here note that FieldName must of DATETIME or DATE Datatype. Also note that output will be in STRING or VARCHAR Datatype.

You can try out with 100 to 116 Different date format as per your requirement.