ASP.Net C# Sql Server javascript jquery Sharepoint: SQL Server Convert datatime format to string

Monday, 12 March 2012

SQL Server Convert datatime format to string

SQL Server - Convert datatime format

CONVERT(VARCHAR(15),OH.ORDERDATE,106) ----> dd MMM yyyy

CONVERT(VARCHAR(15),OH.ORDERDATE,105) ----> dd MM yyyy

CONVERT(VARCHAR(15),OH.ORDERDATE,104) ----> dd.MM.yyyy