SELECT CONVERT(VarChar(20), 'April 29, 1988') : Convert « Data Type « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Data Type
  3. Convert

SELECT CONVERT(VarChar(20), 'April 29, 1988')

 


8> SELECT CONVERT(VarChar(20), 'April 29, 1988')
9> GO

--------------------
April 29, 1988

(1 rows affected)
1>








Related examples in the same category

1.CONVERT function syntax: CONVERT(<target data type>, <expression to be converted>, <style>)
2.CONVERT() Function Styles
3.Format money (currency)
4.CONVERT(varchar,Date,101)
5.SELECT CONVERT(VarChar(50), @Num, 2)
6.Combine CONVERT() and DATEADD() to format
7.Conversion with CONVERT function for computated value with numbers in list