php mysql date operation function_PHP tutorial
The article uses two examples to analyze and introduce the usage and format of PHP dates and MySQL dates. It also includes the field types and query efficiency tests used when MySQL uses dates.
php
int value:
time(): returns the number of seconds since the Unix epoch (00:00:00 Greenwich Mean Time on January 1, 1970) to the current time.
If we want to get the number of seconds from January 1, 1970 to 2012-2-10, we can use strtotime(): that is: strtotime('2012-2-10');
date value:
string date ( string format [, int timestamp] )
For the date() function, please refer to http://www.bKjia.c0m/phper/php-function/38146.htm
For example: directly date() returns the current time, of course we can specify its format:
For example date('Y-m-d',strtotime('2012-2-10'));
Time operation:
| The code is as follows | Copy code | ||||
date('Y-m-d h:i:s' ,strtotime('+1 week'));
date('Y-m-d h:i:s',strtotime('next Monday)); date('Y-m-d h:i:s',strtotime('last Sunday'));
date('Y-m-d h:i:s',strtotime('+ 1 day',12313223));!! See int strtotime ( string time [, int now] ) |
|||||
Date parameters
The format of each parameter is represented separately:
a - "am" or "pm"
a - "am" or "pm"
d - day, two digits, if there are less than two digits, add zeros in front; for example: "01" to "31"
d - day of the week, three English letters; such as: "fri"
f - month, full English name; such as: "january"
h - hour in 12-hour format; e.g.: "01" to "12"
h - hour in 24-hour format; e.g.: "00" to "23"
g - hour in 12-hour format, no zeros are added if there are less than two digits; such as: "1" to 12"
g - hour in 24-hour format, no zeros are added if there are less than two digits; such as: "0" to "23"
i - minute; e.g.: "00" to "59"
j - day, two digits, if there are less than two digits, do not add zeros; for example: "1" to "31"
l - day of the week, full English name; such as: "friday"
m - month, two digits, if there are less than two digits, add zeros in front; such as: "01" to "12"
n - month, two digits, if there are less than two digits, no zero will be added; for example: "1" to "12"
m - month, three English letters; such as: "jan"
s - seconds; e.g.: "00" to "59"
s - add an English ordinal number at the end of the word, two English letters; such as: "th", "nd"
t - the number of days in the specified month; such as: "28" to "31"
u - Total seconds
w - Numeric day of the week, such as: "0" (Sunday) to "6" (Saturday) y - year, four digits; such as: "1999"
y - year, two digits; such as: "99"
z - day of the year; e.g.: "0" to "365"
| 代码如下 | 复制代码 |
| int->datetime select from_unixtime(int_time) from table; datetime->int; select unix_timestamp(date_time) from table; |
|
| 代码如下 | 复制代码 |
| select dayofweek('2012-2-2');返回一个星期的第几天 select dayofmonth('2012-2-2');返回一月中的第几天 select dayofyear('2012-2-2');返回一年中的第几天 |
|
| The code is as follows | Copy code |
| int->datetime select from_unixtime(int_time) from table; datetime->int; select unix_timestamp(date_time) from table; | |
| The code is as follows | Copy code |
| select dayofweek('2012-2-2' );Returns the day of the week select dayofmonth('2012-2-2'); Returns the day of the month select dayofyear('2012-2-2'); Returns the day of the year | |
Similar functions: month() day() hour() week()......
+days date_add(date,interval 2 days);
-How many days date_sub(date,interval 2 days);
Time format:
date_format(date,format)
select DATE_FORMAT('1997-10-04 22:23:00','%W %M %Y');
Other functions: TIME_TO_SEC() SEC_TO_TIME()...
Finally, let’s summarize the query efficiency comparison of using int, varchar, and datetime in the database when using time.
Test the update of four tables, update 100 records respectively, and record the time: Beijing PHP Resource Sharing Portal d*V.~ x G/Q O
Table 1: Page running time: 2.62180089951 seconds (non-fixed length, int time) Beijing PHP Resource Sharing Portal
Table 2: Page running time: 2.5475358963 seconds (fixed length, int time)
Table 3: Page running time: 2.45077300072 seconds (varchar, datetime time)
Table 4: Page running time: 2.82798409462 seconds (char, datetime time)
Under large data volumes, if there are a large number of queries such as select * from table where time >XX, it makes sense to use int for datetime in MySQL 5.1.
php mysql date comparison code
More and better details http://www.bKjia.c0m/phper/21/d40b994ac43e630f316940ea4976564c.htm
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
PHP and Python: Comparing Two Popular Programming Languages
Apr 14, 2025 am 12:13 AM
PHP and Python each have their own advantages, and choose according to project requirements. 1.PHP is suitable for web development, especially for rapid development and maintenance of websites. 2. Python is suitable for data science, machine learning and artificial intelligence, with concise syntax and suitable for beginners.
PHP's Purpose: Building Dynamic Websites
Apr 15, 2025 am 12:18 AM
PHP is used to build dynamic websites, and its core functions include: 1. Generate dynamic content and generate web pages in real time by connecting with the database; 2. Process user interaction and form submissions, verify inputs and respond to operations; 3. Manage sessions and user authentication to provide a personalized experience; 4. Optimize performance and follow best practices to improve website efficiency and security.
The Enduring Relevance of PHP: Is It Still Alive?
Apr 14, 2025 am 12:12 AM
PHP is still dynamic and still occupies an important position in the field of modern programming. 1) PHP's simplicity and powerful community support make it widely used in web development; 2) Its flexibility and stability make it outstanding in handling web forms, database operations and file processing; 3) PHP is constantly evolving and optimizing, suitable for beginners and experienced developers.
PHP in Action: Real-World Examples and Applications
Apr 14, 2025 am 12:19 AM
PHP is widely used in e-commerce, content management systems and API development. 1) E-commerce: used for shopping cart function and payment processing. 2) Content management system: used for dynamic content generation and user management. 3) API development: used for RESTful API development and API security. Through performance optimization and best practices, the efficiency and maintainability of PHP applications are improved.
PHP and Python: Different Paradigms Explained
Apr 18, 2025 am 12:26 AM
PHP is mainly procedural programming, but also supports object-oriented programming (OOP); Python supports a variety of paradigms, including OOP, functional and procedural programming. PHP is suitable for web development, and Python is suitable for a variety of applications such as data analysis and machine learning.
PHP and Python: Code Examples and Comparison
Apr 15, 2025 am 12:07 AM
PHP and Python have their own advantages and disadvantages, and the choice depends on project needs and personal preferences. 1.PHP is suitable for rapid development and maintenance of large-scale web applications. 2. Python dominates the field of data science and machine learning.
Why Use PHP? Advantages and Benefits Explained
Apr 16, 2025 am 12:16 AM
The core benefits of PHP include ease of learning, strong web development support, rich libraries and frameworks, high performance and scalability, cross-platform compatibility, and cost-effectiveness. 1) Easy to learn and use, suitable for beginners; 2) Good integration with web servers and supports multiple databases; 3) Have powerful frameworks such as Laravel; 4) High performance can be achieved through optimization; 5) Support multiple operating systems; 6) Open source to reduce development costs.
PHP: Handling Databases and Server-Side Logic
Apr 15, 2025 am 12:15 AM
PHP uses MySQLi and PDO extensions to interact in database operations and server-side logic processing, and processes server-side logic through functions such as session management. 1) Use MySQLi or PDO to connect to the database and execute SQL queries. 2) Handle HTTP requests and user status through session management and other functions. 3) Use transactions to ensure the atomicity of database operations. 4) Prevent SQL injection, use exception handling and closing connections for debugging. 5) Optimize performance through indexing and cache, write highly readable code and perform error handling.
