Convert « Data Type « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Data Type
  3. Convert
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.SELECT CONVERT(VarChar(20), 'April 29, 1988')
8.Conversion with CONVERT function for computated value with numbers in list