where timestamp ó¸®
timestamp ¼Ó¼º °ª¿¡¼ date·Î ³¯Â¥ °Ë»öÀ» ÇÏ´Â °æ¿ì
¾Æ·¡¿Í °°ÀÌ Ã³¸®ÇÑ Äõ¸®°¡ ¸¹ÀÌ Àִµ¥
Áö±Ý ³¯Â¥·Î À妽º°¡
°É¸° Å×À̺íÀº A, BÀÇ Äõ¸® °á°ú°¡ Â÷ÀÌ°¡ º°·Î ¾ø´Âµ¥
À妽º ÀâÀ¸¸é Â÷ÀÌ°¡ ¸¹ÀÌ ³ª³×¿ä.
Àú´Â Äõ¸®¸¦ º¯°æÇÏ´Â°Ô ¹ø°Å·Î¿ö¼
ÇÔ¼ö·Î Çѹæ(?)¿¡ ó¸®ÇÑ´Ù°í Àú·¸°Ô Çß½À´Ï´Ù¸¸....
º¸´Ï ¸¹À̵é A¹æ¹ýÀ¸·Î ¾²¼Ì´õ¶ó±¸¿ä.
Æ´Æ´È÷ ¼öÁ¤ µÉ¶§ BÀÇ ¹æ¹ýÀ¸·Î
¼öÁ¤ÇϽøé ÁÁÀ»µí ÇÕ´Ï´Ù.
A)
select
count(*) from
a
where
DATE_FORMAT(reg_dt, '%Y/%m/%d') = '2010/03/01'
B)
select
count(*) from
a
where
reg_dt >= DATE_FORMAT( '2010/03/01' ,'%Y-%m-%d
00:00:00')
AND reg_dt < DATE_FORMAT(DATE_ADD( '2010/03/01' ,
INTERVAL 1 DAY),'%Y-%m-%d 00:00:00')
Table 11.12. Date/Time Functions
Name | Description |
---|---|
ADDDATE() (v4.1.1) |
Add time values (intervals) to a date value |
ADDTIME() (v4.1.1) |
Add time |
CONVERT_TZ() (v4.1.3) |
Convert from one timezone to another |
CURDATE() |
Return the current date |
CURRENT_DATE() ,
CURRENT_DATE |
Synonyms for CURDATE() |
CURRENT_TIME() ,
CURRENT_TIME |
Synonyms for CURTIME() |
CURRENT_TIMESTAMP() ,
CURRENT_TIMESTAMP |
Synonyms for NOW() |
CURTIME() |
Return the current time |
DATE_ADD() |
Add time values (intervals) to a date value |
DATE_FORMAT() |
Format date as specified |
DATE_SUB() |
Subtract a time value (interval) from a date |
DATE() (v4.1.1) |
Extract the date part of a date or datetime expression |
DATEDIFF() (v4.1.1) |
Subtract two dates |
DAY() (v4.1.1) |
Synonym for DAYOFMONTH() |
DAYNAME() (v4.1.21) |
Return the name of the weekday |
DAYOFMONTH() |
Return the day of the month (0-31) |
DAYOFWEEK() |
Return the weekday index of the argument |
DAYOFYEAR() |
Return the day of the year (1-366) |
EXTRACT() |
Extract part of a date |
FROM_DAYS() |
Convert a day number to a date |
FROM_UNIXTIME() |
Format UNIX timestamp as a date |
GET_FORMAT() (v4.1.1) |
Return a date format string |
HOUR() |
Extract the hour |
LAST_DAY (v4.1.1) |
Return the last day of the month for the argument |
LOCALTIME() , LOCALTIME |
Synonym for NOW() |
LOCALTIMESTAMP , LOCALTIMESTAMP() (v4.0.6) |
Synonym for NOW() |
MAKEDATE() (v4.1.1) |
Create a date from the year and day of year |
MAKETIME (v4.1.1) |
MAKETIME() |
MICROSECOND() (v4.1.1) |
Return the microseconds from argument |
MINUTE() |
Return the minute from the argument |
MONTH() |
Return the month from the date passed |
MONTHNAME() (v4.1.21) |
Return the name of the month |
NOW() |
Return the current date and time |
PERIOD_ADD() |
Add a period to a year-month |
PERIOD_DIFF() |
Return the number of months between periods |
QUARTER() |
Return the quarter from a date argument |
SEC_TO_TIME() |
Converts seconds to 'HH:MM:SS' format |
SECOND() |
Return the second (0-59) |
STR_TO_DATE() (v4.1.1) |
Convert a string to a date |
SUBDATE() |
A synonym for DATE_SUB() when invoked with three arguments |
SUBTIME() (v4.1.1) |
Subtract times |
SYSDATE() |
Return the time at which the function executes |
TIME_FORMAT() |
Format as time |
TIME_TO_SEC() |
Return the argument converted to seconds |
TIME() (v4.1.1) |
Extract the time portion of the expression passed |
TIMEDIFF() (v4.1.1) |
Subtract time |
TIMESTAMP() (v4.1.1) |
With a single argument, this function returns the date or datetime expression; with two arguments, the sum of the arguments |
TO_DAYS() |
Return the date argument converted to days |
UNIX_TIMESTAMP() |
Return a UNIX timestamp |
UTC_DATE() (v4.1.1) |
Return the current UTC date |
UTC_TIME() (v4.1.1) |
Return the current UTC time |
UTC_TIMESTAMP() (v4.1.1) |
Return the current UTC date and time |
WEEK() |
Return the week number |
WEEKDAY() |
Return the weekday index |
WEEKOFYEAR() (v4.1.1) |
Return the calendar week of the date (0-53) |
YEAR() |
Return the year |
YEARWEEK() |
Return the year and week |
Âü°í http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html