convert(char(29),datetime,109)
Aug 13 2013 04:10:02:000 PM
dd/MM/yyyy 04:10:02 PM
13/08/2013 04:10:02PM
declare @mydate datetime = getdate() select convert(varchar,@mydate, 103) + right(convert(varchar,@mydate,100),8)
Format(DateTime.Now, "dd/MM/yyyy hh:mm:ss tt") 'or DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss tt")
DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss tt");
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)