TIMESTAMP(expr) returns the date or datetime expression expr as a datetime value : TIMESTAMP : Date Time Functions MySQL TUTORIALS

MySQL TUTORIALS » Date Time Functions » TIMESTAMP »

TIMESTAMP(expr) returns the date or datetime expression expr as a datetime value


mysql>
mysql> SELECT TIMESTAMP('2003-12-31');
+-------------------------+
| TIMESTAMP('2003-12-31') |
+-------------------------+
| 2003-12-31 00:00:00     |
+-------------------------+
1 row in set (0.00 sec)

mysql>

Related Scripts with Example Source Code in same category :

TIMESTAMP(expr1,expr2) adds the time expression expr2 to the date or datetime expression expr1 and returns the result as a datetime value.

MySQL TUTORIALS

Date Time Functions
» TIMESTAMP

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

TIMESTAMP(expr) returns the date or datetime expression expr as a datetime value : TIMESTAMP : Date Time Functions MySQL TUTORIALS

MySQL TUTORIALS » Date Time Functions » TIMESTAMP »

TIMESTAMP(expr) returns the date or datetime expression expr as a datetime value

Leave a Comment / Note

MySQL TUTORIALS