Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MySQL v5.7.18 time stamp and time zone problem

CONCEPT21May 5 2017 — edited May 12 2017

Hello!  It is me again!

I have 2 installations of MySQL v5.7.18.  One is on Oracle Linux 7.3 and the other is on Ubuntu 16.04.

Both of their mysql log records show time stamp in GMT (UTC).  I have checked my system OS's time zone setting and they are set correctly to my local time zone GMT+8.

So how do I make the mysql log records being shown in my local time zone?  In the older version of mysql, their log records were shown in my local time zone.

Hope to hear your helpful opinion. 

This post has been answered by CONCEPT21 on May 9 2017
Jump to Answer

Comments

Gaz in Oz

By not showing all your code, it is difficult to say what you have done wrong. Post a VERY SIMPLE and SHORT complete example that shows what you are trying to do and how you are trying to do it...

The actual Oracle error ORA-00904 suggests that the query sqlalchemy is throwing to the Oracle database contains a non-existent column name, not an issue with a date or timestamp.

Add debug your code and output to screen the actual query sqlalchemy is trying to send to the database.

As a general tip, use sqlplus to test out "stuff". If you don't already have it on your machine, you can download Oracle instantclient and tools from here:

https://www.oracle.com/technetwork/database/database-technologies/instant-client/overview/index.html

With basic or basic-light and sqlplus installed you can run the above sqlalchemy  debug output query in an Oracle client, connected to the database with the same credentials, and see exactly what line and where the error is occurring. Yo can also "describe" the table you are trying to insert into, or select from, or what ever.

Here's a very simple example sqlplus session with a simple SELECT query failing, to give you an idea of how you would start to debug your above error in sqlplus:

$ sqlplus gaz/gaz@host:port/service_name

...

SQL> select col1,

  2         dummy

  3  from   dual;

select col1,

       *

ERROR at line 1:

ORA-00904: "COL1": invalid identifier

SQL> describe dual

Name                          Null?    Type

----------------------------- -------- --------------------

DUMMY                                  VARCHAR2(1)

SQL> l

  1  select col1,

  2         dummy

  3* from   dual

SQL> 1

  1* select col1,

SQL> c/col1,//

  1* select

SQL> l

  1  select

  2         dummy

  3* from   dual

SQL> /

D

-

X

1 row selected.

SQL>

1 - 1

Post Details

Added on May 5 2017
5 comments
183 views