"BORDER-RIGHT: black 0.5pt solid; WIDTH: 537pt; HEIGHT: 13.5pt"
width="716" colspan="4" height="18">datetime 변경 style
number |
style
number |
쿼리문 |
결과 |
포맷 |
"BORDER-TOP: medium none; HEIGHT: 13.5pt" height="18">
none |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">select
getdate() |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
2006-03-30 11:18:02.23 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
yyyy-mm-dd hh:mm:ss.ms |
"BORDER-TOP: medium none; HEIGHT: 13.5pt" height="18" x:num=
"">100 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">select
convert(varchar, getdate(), 100) |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">Mar 30
2006 11:20AM |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">mmm dd
yyyy hh:mmAM/PM |
"BORDER-TOP: medium none; HEIGHT: 13.5pt" height="18" x:num=
"">101 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">select
convert(varchar, getdate(), 101) |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
03/30/2006 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
mm/dd/yyyy |
"BORDER-TOP: medium none; HEIGHT: 13.5pt" height="18" x:num=
"">102 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">select
convert(varchar, getdate(), 102) |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
2006.03.30 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
yyyy.mm.dd |
"BORDER-TOP: medium none; HEIGHT: 13.5pt" height="18" x:num=
"">103 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">select
convert(varchar, getdate(), 103) |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
30/03/2006 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
dd/mm/yyyy |
"BORDER-TOP: medium none; HEIGHT: 13.5pt" height="18" x:num=
"">104 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">select
convert(varchar, getdate(), 104) |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
30.03.2006 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
dd.mm.yyyy |
"BORDER-TOP: medium none; HEIGHT: 13.5pt" height="18" x:num=
"">105 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">select
convert(varchar, getdate(), 105) |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
30-03-2006 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
dd-mm-yyyy |
"BORDER-TOP: medium none; HEIGHT: 13.5pt" height="18" x:num=
"">106 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">select
convert(varchar, getdate(), 106) |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">30 Mar
2006 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">dd mmm
yyyy |
"BORDER-TOP: medium none; HEIGHT: 13.5pt" height="18" x:num=
"">107 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">select
convert(varchar, getdate(), 107) |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">Mar 30,
2006 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">mmm
dd,yyyy |
"BORDER-TOP: medium none; HEIGHT: 13.5pt" height="18" x:num=
"">108 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">select
convert(varchar, getdate(), 108) |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
11:24:10 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
hh:mm:ss |
"BORDER-TOP: medium none; HEIGHT: 13.5pt" height="18" x:num=
"">109 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">select
convert(varchar, getdate(), 109) |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">Mar 30
2006 11:25:26:703AM |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">mmm dd
yyyy hh:mm:msAM/PM |
"BORDER-TOP: medium none; HEIGHT: 13.5pt" height="18" x:num=
"">110 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">select
convert(varchar, getdate(), 110) |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
03-30-2006 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
mm-dd-yyyy |
"BORDER-TOP: medium none; HEIGHT: 13.5pt" height="18" x:num=
"">111 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">select
convert(varchar, getdate(), 111) |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
2006/03/30 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
yyyy/mm/dd |
"BORDER-TOP: medium none; HEIGHT: 13.5pt" height="18" x:num=
"">112 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">select
convert(varchar, getdate(), 112) |
"BORDER-TOP: medium none; BORDER-LEFT: medium none" x:num="">
20060330 |
"BORDER-TOP: medium none; BORDER-LEFT: medium none">
yyyymmdd |
