Inserarea datei si timpului in baza de date

[Matei02Mihai]

Salut. Ma puteti ajuta cu inserarea datei si timpului in baza de date? Folosesc easy mysql.

Edited September 20, 2022 by Matei02Mihai

[Trippie]

getdate()*

Edited September 25, 2022 by Trippie

[Pa4enka]

NOW()

or

format(string, sizeofstring, "INSERT INTO table SET unbandate = FROM_UNIXTIME(%d)",gettime+/*days*/);
//....
new timestamp = gettime();
format(query_string, sizeof query_string, 
    "\
        SELECT DATE_FORMAT(unbandate, '%%d.%%m.%%Y %%H:%%i') AS unban_date, \
        DATEDIFF(unbandate, FROM_UNIXTIME(%d)) AS unban_days FROM table \
        WHERE name = '%e' AND UNIX_TIMESTAMP(unbandate) > FROM_UNIXTIME(%d)\
    ",
    timestamp, /*Nick_Name*/, timestamp
);

Edited October 14, 2022 by Pa4enka