简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

MySQL获取系统当前时间的函数

WBOY
Release： 2016-06-07 17:26:06
Original
1869 people have browsed it

MySQL获取系统当前时间的函数，环境：MySQL Server 5.1

环境：MySQL Server 5.1

问题：MySQL获取系统当前时间的函数

解决：

NOW()函数以'YYYY-MM-DD HH:MM:SS'返回当前的日期时间，可以直接存到DATETIME字段中。

CURDATE()以'YYYY-MM-DD'的格式返回今天的日期，，可以直接存到DATE字段中。

CURTIME()以'HH:MM:SS'的格式返回当前的时间，可以直接存到TIME字段中。

示例：

SQL：

select now() as 当前日期时间;
select curdate() as 今天日期;
select curtime() as 当前时间;

linux

Related labels：
MySQL当前时间函数 MySQL获取当前时间 MySQL时
source：php.cn
Previous article：Linux下安装完Oracle 11g后使用sqlplus出现乱码解决 Next article：Oracle权限总结
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Nuxt.js SSG (Static Site Generator) Get API Data When building a project using a static site generator, I understand that documentation cre...
From 2023-11-16 21:36:07
0
1
176
sqlalchemy.exc.ArgumentError: list argument must contain only tuples or dictionaries I've been trying to use sqlalchemy to dump data into a mysql database. When I try to do th...
From 2023-11-07 21:06:02
0
1
286
The title is rewritten as: "Flutter mysql1 received out-of-order packets" I'm having some issues setting up a connection to my VPS using flutter's mysql1 library. W...
From 2023-11-05 22:34:25
0
1
217
"Using the v-for directive for array element and attribute destructuring" When using an array of objects, is it possible in a v-for loop to simultaneously assign th...
From 2023-11-05 17:37:54
0
1
216
How to copy Excel FV function in PHP? I'm converting some fairly complex calculations from an Excel spreadsheet to PHP. I'm stuc...
From 2023-11-04 15:54:09
0
1
254
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！