About this document

SQL DateTime Conversion Techniques by Umakant Parashar is a document available to read on EtoBox.

The CAST and CONVERT functions in SQL Server are used to format datetime values or columns into specific date formats. CAST converts a datetime to a varchar or string. CONVERT changes or converts datetime formats and can return just the date or time portion. CONVERT takes a datetime style parameter to specify the desired format like mm/dd/yy, dd/mm/yyyy, or yyyymmdd. Examples show using CONVERT with GETDATE() and different style parameters to return formatted datetime strings.

Author

Umakant Parashar

Language

EN