L
L
lucsieus2021-03-26 13:09:16
Database administration
lucsieus, 2021-03-26 13:09:16

How to set current time in sql query?

Good afternoon, I immediately warn you that I just embarked on the thorny path of the samurai. And I am in the process of learning being a programmer.

I am writing a bot, I encountered such a problem ---> the time is recorded in the database table:
For such a request --->

INSERT INTO bot_shop_order SET user_id = :user_id, date = NOW() , status = 0, name = :name, phone = :phone, adress = :adress, comment = :comment


The problem is that the time is Europe/Moscow. And I need Asia / Almaty.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
T
ThunderCat, 2021-03-26
@ThunderCat

https://www.google.ru/search?q=mysql+set+timezone

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question