I have created a table with schema cur_date date, cur_time time
. I want to insert the current time and date into the table. When I do so with
INSERT INTO timeDemo VALUES(date(),time());
and
SELECT* FROMtimeDemo
it returns a row with current date but a different time. I executed this query at 4:03 PM
of system time, but the row has 10:22
.
How can I fix it? I run these from cmd.exe .
Aucun commentaire:
Enregistrer un commentaire