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 ...
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, ...
Shelley Doll finishes her coverage of SQL data types with an overview of datetime and interval data types. Learn more about the basic syntax of these standard SQL types. Datetimes and intervals are ...