Getting the Current Date and Time : NOW : Date Time Functions MySQL TUTORIALS

MySQL TUTORIALS » Date Time Functions » NOW »

Getting the Current Date and Time

There are three functions that you can use to get the current date and time.

NOW() gets both date and time.

CURDATE() works with only the date.

CURTIME() is for the time.


mysql>
mysql> SELECT NOW();
+---------------------+
| NOW()               |
+---------------------+
| 2007-07-21 13:54:27 |
+---------------------+
1 row in set (0.00 sec)

Related Scripts with Example Source Code in same category :

Multiple references to a function such as NOW() within a single query always produce the same result
SELECT NOW(), SLEEP(2), NOW();

MySQL TUTORIALS

Date Time Functions
» NOW

Aggregate Functions

Cast Functions Operators

Comparison Functions Operators

Control Flow Functions

Cursor

Data Dictionary

Data Types

Database

Date Time Functions

Encryption Compression Functions

Information Functions

Insert Update Delete

Introduction

Logic Operator

Math Numeric Functions

Miscellaneous Functions

Privilege

Subquery

Table

Table Join

Trigger

View

Getting the Current Date and Time : NOW : Date Time Functions MySQL TUTORIALS

MySQL TUTORIALS » Date Time Functions » NOW »

Getting the Current Date and Time

Leave a Comment / Note

MySQL TUTORIALS