Для вывода даты в формате 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