lionheart

Thank you for your helping!

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.