Search Results for 'date'


1 POSTS

  1. 2009.01.28 mssql 날짜타입 형변환(?)

mssql 날짜타입 형변환(?)

Posted 2009.01.28 16:36 by maxmini MAXMINI


cre_date(datetime)

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

100 : 01 16 2009  2:20PM
101 : 01/16/2009
102 : 2009.01.16
103 : 16/01/2009
104 : 16.01.2009
105 : 16-01-2009
106 : 16 01 2009
107 : 01 16, 2009
108 : 14:20:16
109 : 01 16 2009  2:20:16:683PM
110 : 01-16-2009
111 : 2009/01/16
112 : 20090116
113 : 16 01 2009 14:20:16:683
114 : 14:20:16:683
120 : 2009-01-16 14:20:16
cre_date : 2009-01-16 14:20:16.683

필요한 타입으로 골라쓰자

Tag : , ,

Write your message and submit