MSSQL DateTime Convert.

DECLARE @dateReg datetime

SET @dateReg = GetDate()

SELECT Convert(nvarchar(20), @dateReg, 100) FROM [work] WHERE [idx] = 483

-> 07 15 2005 12:00AM

SELECT Convert(nvarchar(20), @dateReg, 101) FROM [work] WHERE [idx] = 483

-> 07/15/2005

SELECT Convert(nvarchar(20), @dateReg, 102) FROM [work] WHERE [idx] = 483

-> 2005.07.15

SELECT Convert(nvarchar(20), @dateReg, 103) FROM [work] WHERE [idx] = 483

-> 15/07/2005

SELECT Convert(nvarchar(20), @dateReg, 104) FROM [work] WHERE [idx] = 483

-> 15.07.2005

SELECT Convert(nvarchar(20), @dateReg, 105) FROM [work] WHERE [idx] = 483

-> 15-07-2005

SELECT Convert(nvarchar(20), @dateReg, 106) FROM [work] WHERE [idx] = 483

-> 15 07 2005

SELECT Convert(nvarchar(20), @dateReg, 107) FROM [work] WHERE [idx] = 483

-> 07 15, 2005

SELECT Convert(nvarchar(20), @dateReg, 108) FROM [work] WHERE [idx] = 483

-> 12:23:59

SELECT Convert(nvarchar(20), @dateReg, 109) FROM [work] WHERE [idx] = 483

-> 07 15 2005 12:23:59:

SELECT Convert(nvarchar(20), @dateReg, 110) FROM [work] WHERE [idx] = 483

-> 07-15-2005

SELECT Convert(nvarchar(20), @dateReg, 111) FROM [work] WHERE [idx] = 483

-> 2005/07/15

SELECT Convert(nvarchar(20), @dateReg, 112) FROM [work] WHERE [idx] = 483

-> 20050715

SELECT Convert(nvarchar(20), @dateReg, 113) FROM [work] WHERE [idx] = 483

-> 19 07 2005 12:23:36:

SELECT Convert(nvarchar(20), @dateReg, 114) FROM [work] WHERE [idx] = 483

-> 12:23:59:793