Формат даты

     Для вывода даты в формате DD.MM.YYYY

SomeDate = CONVERT(VarChar(50), getdate(), 104)

   Выведется текущая дата в указанном формате. Формат указывается цифрами, в данном случае 104. 

      Остальные значения:

SELECT CONVERT(varchar, getdate(), 2)    -- 'yy.mm.dd'
SELECT CONVERT(varchar, getdate(), 3)    -- 'dd/mm/yy'
SELECT CONVERT(varchar, getdate(), 4)    -- 'dd.mm.yy'
SELECT CONVERT(varchar, getdate(), 5)    -- 'dd-mm-yy'
SELECT CONVERT(varchar, getdate(), 6)    -- 'dd mmm yy'
SELECT CONVERT(VarChar, GETDATE(), 101)  -- 'mm/dd/yyyy'
SELECT CONVERT(VarChar, GETDATE(), 102)  -- 'yyyy.mm.dd'
SELECT CONVERT(VarChar, GETDATE(), 103)  -- 'dd/mm/yyyy'
SELECT CONVERT(VarChar, GETDATE(), 104)  -- 'dd.mm.yyyy'
SELECT CONVERT(varchar, GETDATE(), 105)  -- 'dd-mm-yyy'
SELECT CONVERT(varchar, GETDATE(), 111)  -- 'yyyy/mm/dd'
SELECT CONVERT(varchar, GETDATE(), 112)  -- 'yyyymmdd'

SELECT CONVERT(varchar,GETDATE(),108) 'hh:mm:ss'
SELECT CONVERT(varchar,GETDATE(),114) 'hh:mm:ss:mmm'
SELECT CONVERT(varchar,GETDATE(),113) 'dd Mmm yyyy hh:mm:ss:mmm'
SELECT CONVERT(VarChar(50), GETDATE(), 100) 'mmm dd yyyy mm:ss AM'

 
     и еще: 

SELECT CONVERT(varchar,GETDATE(),0)
Return Value = Jun 6 2007 11:07PM
SELECT CONVERT(varchar,GETDATE(),100)
Return Value = Jun 6 2007 11:07PM

SELECT CONVERT(varchar,GETDATE(),1)
Return Value = 06/06/07
SELECT CONVERT(varchar,GETDATE(),101)
Return Value = 06/06/2007

SELECT CONVERT(varchar,GETDATE(),2)
Return Value = 07.06.06
SELECT CONVERT(varchar,GETDATE(),102)
Return Value = 2007.06.06

SELECT CONVERT(varchar,GETDATE(),3)
Return Value = 06/06/07
SELECT CONVERT(varchar,GETDATE(),103)
Return Value = 06/06/2007

SELECT CONVERT(varchar,GETDATE(),4)
Return Value = 06.06.07
SELECT CONVERT(varchar,GETDATE(),104)
Return Value = 06.06.2007

SELECT CONVERT(varchar,GETDATE(),5)
Return Value = 06-06-07
SELECT CONVERT(varchar,GETDATE(),105)
Return Value = 06-06-2007

SELECT CONVERT(varchar,GETDATE(),6)
Return Value = 06 Jun 07
SELECT CONVERT(varchar,GETDATE(),106)
Return Value = 06 Jun 2007

SELECT CONVERT(varchar,GETDATE(),7)
Return Value = Jun 06, 07
SELECT CONVERT(varchar,GETDATE(),107)
Return Value = Jun 06, 2007

SELECT CONVERT(varchar,GETDATE(),8)
Return Value = 23:38:49
SELECT CONVERT(varchar,GETDATE(),108)
Return Value = 23:38:49

SELECT CONVERT(varchar,GETDATE(),9)
Return Value = Jun 6 2007 11:39:17:060PM
SELECT CONVERT(varchar,GETDATE(),109)
Return Value = Jun 6 2007 11:39:17:060PM

SELECT CONVERT(varchar,GETDATE(),10)
Return Value = 06-06-07
SELECT CONVERT(varchar,GETDATE(),110)
Return Value = 06-06-2007

SELECT CONVERT(varchar,GETDATE(),11)
Return Value = 07/06/06
SELECT CONVERT(varchar,GETDATE(),111)
Return Value = 2007/06/06

SELECT CONVERT(varchar,GETDATE(),12)
Return Value = 070606
SELECT CONVERT(varchar,GETDATE(),112)
Return Value = 20070606

SELECT CONVERT(varchar,GETDATE(),13)
Return Value = 06 Jun 2007 23:40:14:577
SELECT CONVERT(varchar,GETDATE(),113)
Return Value = 06 Jun 2007 23:40:14:577

SELECT CONVERT(varchar,GETDATE(),14)
Return Value = 23:40:29:717
SELECT CONVERT(varchar,GETDATE(),114)
Return Value = 23:40:29:717

SELECT CONVERT(varchar,GETDATE(),20)
Return Value = 2007-06-06 23:40:51
SELECT CONVERT(varchar,GETDATE(),120)
Return Value = 2007-06-06 23:40:51

SELECT CONVERT(varchar,GETDATE(),21)
Return Value = 2007-06-06 23:41:10.153
SELECT CONVERT(varchar,GETDATE(),121)
Return Value = 2007-06-06 23:41:10.153

SELECT CONVERT(varchar,GETDATE(),126)
Return Value = 2007-06-06T23:41:10.153

SELECT CONVERT(varchar,GETDATE(),131)
Return Value = 21/05/1428 11:41:10:153PM