³¯Â¥ ¶Ç´Â ½Ã°£À¸·Î Çü½ÄÈµÈ ½ÄÀ» ¹ÝȯÇÕ´Ï´Ù.
FormatDateTime(Time(), 4) => 17:22 ÀÇ °æ¿ì ½Ã°£°ú ºÐÀ» Ãâ·ÂÇÕ´Ï´Ù
±×·³ ½Ã°£°ú ºÐÀ» ºÐ¸®ÇÒ·Á¸é?
Split ÇÔ¼ö¸¦ »ç¿ëÇÒ¼ö ÀÖ½À´Ï´Ù
oneDateTime=FormatDateTime(Time(), 4)
SplitTimes=Split(OneDateTime,":")
SplitTimes(0) : ÀǰªÀº 24½Ã°£Á¦¸¦ ³ªÅ¸³¾¼ö ÀÖ½À´Ï´Ù
SplitTimes(1) : ÀǰªÀº ºÐÀ» ³ªÅ¸³¾¼ö ÀÖ½À´Ï´Ù
³ª¸ÓÁö´Â ¿©·¯ºÐÀÇ ÀÀ¿ë¹®Á¦ÀÏ°Í °°½À´Ï´Ù
FormatDateTime(Date[,NamedFormat])
Date :
ÇʼöÀûÀÎ Àμö. ³¯Â¥½ÄÀ» ÁöÁ¤ÇÕ´Ï´Ù
NamedFormat :
¼±ÅÃÀûÀÎ Àμö. »ç¿ëÇÑ ³¯Â¥/½Ã°£ Çü½ÄÀ» ³ªÅ¸³»´Â ¼ýÀÚ °ªÀÔ´Ï´Ù.
ÀÌ Àμö¸¦ »ý·«Çϸé vbGeneralDate¸¦ »ç¿ëÇÕ´Ï´Ù.
NamedFormat Àμö´Â ¾Æ·¡ ¼³Á¤À» °¡Áý´Ï´Ù.
»ó¼ö
°ª
¼³¸í
---------------------------------------------
vbGeneralDate
0
³¯Â¥ ¶Ç´Â ½Ã°£À» Ç¥½ÃÇÕ´Ï´Ù. ³¯Â¥ ºÎºÐÀÌ ÀÖÀ¸¸é °£´ÜÇÏ°Ô Ç¥½Ã ³¯Â¥ Çü½ÄÀ¸·Î ³¯Â¥¸¦ Ç¥½ÃÇϸç, ½Ã°£ ºÎºÐÀÌ ÀÖÀ¸¸é ÀÚ¼¼ÇÏ°Ô Ç¥½Ã ½Ã°£ Çü½ÄÀ¸·Î ½Ã°£À» Ç¥½ÃÇÕ´Ï´Ù. ³¯Â¥¿Í ½Ã°£ÀÌ °°ÀÌ ÀÖÀ¸¸é µÎ ºÎºÐÀ» ¸ðµÎ Ç¥½ÃÇÕ´Ï´Ù.
---------------------------------------------
vbLongDate
1
ÄÄÇ»ÅÍÀÇ ±¹°¡º° ¼³Á¤¿¡¼ ÁöÁ¤ÇÑ ÀÚ¼¼ÇÏ°Ô Ç¥½Ã ³¯Â¥ Çü½ÄÀ¸·Î ³¯Â¥¸¦ Ç¥½ÃÇÕ´Ï´Ù.
---------------------------------------------
vbShortDate
2
ÄÄÇ»ÅÍÀÇ ±¹°¡º° ¼³Á¤¿¡¼ ÁöÁ¤ÇÑ °£´ÜÇÏ°Ô Ç¥½Ã ³¯Â¥ Çü½ÄÀ¸·Î ³¯Â¥¸¦ Ç¥½ÃÇÕ´Ï´Ù
---------------------------------------------
vbLongTime
3
ÄÄÇ»ÅÍÀÇ ±¹°¡º° ¼³Á¤¿¡¼ ÁöÁ¤ÇÑ ½Ã°£ Çü½ÄÀ¸·Î ½Ã°£À» Ç¥½ÃÇÕ´Ï´Ù
---------------------------------------------
vbShortTime
4
24½Ã°£ Çü½Ä(hh:mm)ÀÇ ½Ã°£À» Ç¥½ÃÇÕ´Ï´Ù.
¿¹Á¦ ---------------------------------------
FormatDateTime("2006-11-17 17:05:22", 0) => 2004-11-17 ¿ÀÈÄ 5:05:22
FormatDateTime("2006-11-17 17:05:22", 1) => 2006³â 11¿ù 17ÀÏ ¸ñ¿äÀÏ
FormatDateTime("2006-11-17 17:05:22", 2) => 2006-11-17
FormatDateTime("2006-11-17 17:05:22", 3) => ¿ÀÈÄ 5:05:22
FormatDateTime("2006-11-17 17:05:22", 4) => 17:22
<%
response.write "now : " & now & "<br>" & vbcrlf
response.write "now + 1 : " & (now+1) & "<br>" & vbcrlf
response.write "date : " & date & "<br>" & vbcrlf
response.write "dateadd : " & DateAdd("m", 1, "31-Jan-95") & "<br>" & vbcrlf
response.write "datediff : " & DateDiff("d", DateAdd("m", 1, "31-Jan-95"),Now) & "<br>" & vbcrlf
response.write "datepart : " & DatePart("q", now) & "<br>" & vbcrlf
response.write "dateserial : " & DateSerial(1990 - 10, 8 - 2, 1 - 1) & "<br>" & vbcrlf
response.write "DateValue : " & DateValue("September 11, 1963") & "<br>" & vbcrlf
response.write "time : " & Time & "<br>" & vbcrlf
response.write "Timeserial : " & TimeSerial(12 - 6, -15, 0) & "<br>" & vbcrlf
response.write "timevalue : " & TimeValue("4:35:17 PM") & "<br>" & vbcrlf
theday="00-11-08 ¿ÀÀü 9:50:31"
response.write isdate(theday) & "<BR>" & vbcrlf
response.write "second : " & second(now) & "<br>" & vbcrlf
response.write "second : " & second(theday) & "<br>" & vbcrlf
response.write "minute : " & Minute(now) & "<br>" & vbcrlf
response.write "hour : " & Hour(now) & "<br>" & vbcrlf
response.write "day : " & day(now) & "<br>" & vbcrlf
response.write "weekday : " & weekday(now) & "<br>" & vbcrlf
response.write "weekdayname : " & weekdayname(weekday(now)) & "<br>" & vbcrlf
response.write "month : " & month(now) & "<br>" & vbcrlf
response.write "monthname : " & monthname(month(now)) & "<br>" & vbcrlf
response.write "year : " & year(now) & "<br>" & vbcrlf
%>
DateDiff ´Â µÎ ½Ã°£À» ºñ±³ÇÏ´Â ÇÔ¼ö ÀÔ´Ï´Ù.
DateDiff("¸ðµå",ºñ±³1,ºñ±³2)
¸ð µå |
¼³ ¸í |
¸ð µå |
¼³ ¸í |
yyyy |
³â |
w |
¿äÀÏ |
q |
ºÐ±â |
ww |
ÁÖ(Àϳâ±âÁØ) |
m |
¿ù |
h |
½Ã |
y |
ÀÏ(Àϳâ±âÁØ) |
n |
ºÐ |
d |
ÀÏ |
s |
ÃÊ |
±×·¡¼ À§ÀÇ ¼Ò½º¸¦ º¸¸é..
rs("writeday") ¿Í ÇöÀçÀÇ ½Ã°£ÀÎ nowday ¸¦ ºñ±³Çؼ ±× »çÀÌÀÇ ÀÏ (day).. ³¯Â¥°¡ 2ÀÏÀüÀ̶ó¸é ÃÖ±ÙÀÇ ±ÛÀ̶ó´Â°É ³ªÅ¸³»°í, 2ÀÏÀÌ Áö³µ´Ù¸é ÃÖ±ÙÀÇ ±ÛÀÌ ¾Æ´Ï¶ó ´Â°ÍÀ» ³ªÅ¸³À´Ï´Ù.