mysql 如何获取 每天早上 9 点的 unix 时间戳？

Question

1.各位大神，mysql 如何获取 每天早上 9 点的 unix 时间戳啊，弄了好久都没有成功

Answer 1

I don’t know if there is a better way

select unix_timestamp(CONCAT(curdate(),' 09:00:00'));

Answer 2

The time of mysql comes from the time on the server, and the server must be set with ntp.
I don’t understand what you said about getting the unix timestamp at 9 o’clock. UNIX_TIMESTAMP can convert the timestamp.

Do you want a scheduled task at 9 o'clock every morning?

Answer 3

Use MySQL event and you will understand