What is the most convenient way to generate datetime in SQL ?

Question

Hello,

SQL beginner here !

What is the most convenient way to create datetime objects within an SQL function, especially generating a datetime object for a given day, month, and year?

Thanks !

Answer 1

Everything you want to know about MySQL datetime functions is right here. Well, probably most everything.

Answer 2

In MySQL

CAST('YYYY-MM-DDThh:mm:ss:uuuuuu' AS datetime)

where:
YYYY: Year
MM : Month
DD : Day
hh : Hour
mm : Minutes
ss : Seconds
uuuuuu : Microseconds

EDIT: I changed from mmm (miliseconds) to uuuuuu (microseconds) since MySQL suports 6 digits

Answer 3

Given a datetime column: INSERT INTO Table ('datetime_column') VALUES (CURDATE( ))

Given a timestamp: INSERT INTO Table ('timestamp_column') VALUES (CURTIME())

Using unix time: INSERT INTO Table ('timestamp_column') VALUES (UNIX_TIMESTAMP())