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 : date, maxmini, MSSQL

내가 사랑하는 사람

Posted 2009.01.28 15:34 by maxmini MAXMINI

2005년 3월 2일 필리핀 세부에서..

Tag : maxmini

이건 무슨 사진인고...어디서 찍었게? ㅋㅋ

Posted 2008.08.18 15:17 by maxmini MAXMINI

오래전..언젠가...어디에서..찍은 셀카...

사용자 삽입 이미지

Tag : maxmini