You want ISO8601 formats in SQL Server, here you go. In SQL Server 2014 forward you can do this... select Format(GetDate(), 'yyyy-MM-dd HH:mm:ss.ffffff') I'm not sure exactly when that came into ...

Format "120" is 24-hour time, down to the second. But we limit the size of the result to remove the time component. To include the time component just use a varchar that is 19 or more characters long, ...

I'm supporting an application that displays a DateTime value in a ListBox control on an ASP.NET page. Currently the list box might contain values such as "01/01/2011 12:00:00". The list box gets ...