Date and Time functionsThis chapter discusses some functions that can be used to manipulate time values. See section 11.3, "Date and Time type" for valid formats for each time and date type with a range and a specified value.
The following example
MySQL
For the value range of each type and the valid format of the specified date value, see 7.3.6 Date and Time type.
Here is an example of using the date function. The following query Selects all records. The value of date_col is within the last 3
The following query selects the records for all date_col values within the last 30 days.
Mysql> SELECT something from Tbl_name
WHERE To_days (now ())-To_days (Date_col) DayOfWeek (date)
Returns the week index of date (1 = Sunday, 2 = Monday, ...). 7
Mysql> SELECT something from Tbl_name
WHERE To_days (now ()) –to_days (date_col)
DayOfWeek (date)
Returns the week index of date (1 = Sunday, 2 = Monday, ...). 7 = Saturday). Index values are compliant with ODBC standards.
mysql> SELECT DayOfWeek ('
Here is an example of using the date function. The following query Selects all records whose date_col values are within the last 30 days.
Here is an example of using the date function. The following query Selects all records whose date_col values
PHP date query function code
Date_default_timezone_set ('prc'); // Default time zone
Echo "today:", date ("Y-m-d", time ()),"";
Echo "today:", date ("Y-m-d", strtotime ("18 Jun 2008 ")),"";
Echo
MySQL date and time function large Summary here is an example of using a date function. The following query selects all records whose Date_col value is within the last 30 days: MySQL select something from table WHERE to_days (now ())-to_days
Here is an example of using the date function. The following query Selects all records, and its date_col is within the last 30 days: mysqlSELECTsomethingFROMtableWHERETO_DAYS (NOW ())
Here is an example of using the date function. The following
In Mysql, the date and time function applications do not need to ask for help. For more information about mysql learning, see.
In Mysql, the date and time function applications do not need to ask for help. For more information about mysql learning,
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.