10 recommended articles about php date_add() function

For articles about the php date_add() function, welcome to read

1. iis php mysql PHP Mysql programming advanced skills

Introduction: iis php mysql: iis php mysql PHP Mysql programming advanced skills: The author made the following attempts.

##2. Mysql function Advanced skills in PHP programming - using Mysql function

Introduction: Mysql function: Mysql function Advanced skills in PHP programming - using Mysql function: Although PHP provides us with many functions, some things are still not very convenient to process, such as the date and time functions provided by PHP. Very limited. Mysql provides us with many such functions. Can I use Mysql functions to process PHP programs?

##3.

PHP Mysql Programming Advanced Skills_PHP Tutorial

Introduction: Advanced skills in PHP Mysql programming. The author made the following attempts?php $data_time="1998-12-31 23:59:59"; $connect_id=mysql_connect('localhost'); $query_id. =mysql_query("SELECT DATE_ADD('$data_time',INTERVAL 1 YEAR)",$

##4.

Advanced skills of PHP Mysql programming

Introduction: Advanced skills in PHP Mysql programming. The author made the following attempts?php $data_time="1998-12-31 23:59:59"; $connect_id=mysql_connect('localhost'). ; $query_id=mysql_query("SELECT DATE_ADD('$data_time',INTERVAL 1 YEAR)",$

5.

mysql date addition date time DATE_ADD() function

Introduction:

6.

MySQL lists all dates in a certain month or within a known date range

Introduction: set @mycnt = 0;select date_add(quot;2008-07-31quot;,interval @mycnt :=@mycnt + 1 day) as day from t_prehandle_qeesoo_0

7.

mysql date_add date_sub

Introduction : The built-in functions date_add and date_sub in mysql can increase or decrease the specified time by a specified time interval. The syntax is as follows: DATE_ADD(date,INTERVAL expr type)DATE_SUB(date,INTERVAL expr type) where date is the specified date, INTERVAL is the keyword, expr is the specific time interval, and type is the time unit. Note

8.

Mysql_date increase and decrease related issues

Introduction: Mysql_date increase and decrease issue select curdate (); ? ? ? ? ? ? ? ? ? ? ? #Get the current date select last_day(curdate()); ? ? ? ? ? ? ? ? ? ?#Get the last day of the month. select DATE_ADD(curdate(),interval -day(curdate())+1 day); ? #Get the first day of this month select date_add(curdate

9.

mysql Time-side query within two weeks

Introduction: mysql Time-side query within two weeks select title,like_count,create_time from housing_guide where status = 2 and create_time between date_add(now( ), interval -15 day) and date_add(now(), interval -1 day) order by create_time desc;

10.

mysql conditional query if case usage

Introduction: where condition query code is as follows select * from news where DATE(adddate) between '2011-04-20'

The above is the detailed content of 10 recommended articles about php date_add() function. For more information, please follow other related articles on the PHP Chinese website!