프로그램/MsSql

Mssql 날짜타입 형변환 참고

서.라.연 2012. 9. 3. 01:51

 

 날짜 형변환  

select
convert(varchar, getdate() ,100),
convert(varchar, getdate() ,101),
convert(varchar, getdate() ,102),
convert(varchar, getdate() ,103),
convert(varchar, getdate() ,104),
convert(varchar, getdate() ,105),
convert(varchar, getdate() ,106),
convert(varchar, getdate() ,107),
convert(varchar, getdate() ,108),
convert(varchar, getdate() ,109),
convert(varchar, getdate() ,110),
convert(varchar, getdate() ,111),
convert(varchar, getdate() ,112),
convert(varchar, getdate() ,113),
convert(varchar, getdate() ,114),
convert(varchar, getdate() ,120),
getdate()
from dual

결과--------------------------------------

100 - 12 17 2009 10:26AM

101 - 12/17/2009

102 - 2009.12.17

103 - 17/12/2009

104 - 17.12.2009

105 - 17-12-2009

106 - 17 12 2009

107 - 12 17, 2009

108 - 10:26:50

109 - 12 17 2009 10:26:50:267AM

110 - 12-17-2009

111 - 2009/12/17

112 - 20091217

113 - 17 12 2009 10:26:50:267

114 - 10:26:50:267

120 - 2009-12-17 10:26:50

     - 2009-12-17 10:26:50.267

ex)============================================================================

select
            convert(varchar(10),getdate(),112),
            convert(varchar(08),getdate(),112)+replace(convert(varchar(08),getdate(),108),':',''),
            convert(varchar(10),getdate(),120)
from dual

==============================================================================