[Char 6 Can't Convert Timestamp]

Thank you for your helping!

[Char 6 Can't Convert Timestamp]

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.