I have a issue about UTC_TIME() and CURTIME().
When I typed this command in windows DOS prompt of mysql client
"SELECT CONVERT_TZ(UTC_TIMESTAMP(), 'UTC', 'Asia/Taipei');" , the client show that the time have converted to the Taipei time.
But when i entered this following command { page 192, step 5 add new records to the messages table:
SELECT INTO messages (parent_id, forum_id, user_id, subject, body, date_entered) VALUES (0, 1, 1, 'Question about normaliztion.' ......}.
I see the time of the column - 'date_entered' is not Taipei time in phpMyAdmin.
So I typed the following commands:
SELECT CURTIME();
SELECT UTCTIMESTAMP();
and they show the two different times.
Help
This is the snapshot picture.