How to calculate the amount from the beginning of the day?

G

GRO242020-05-13 23:29:29

MySQL

GRO24, 2020-05-13 23:29:29

How can I implement a query that will count not for the last day, but only from 00:00?
That is, >= now() - interval 1 day is not suitable.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

A

Adamos, 2020-05-14
@GRO24

We take the List of MySQL functions for working with date and time and read at least up to the fourth line.

I

ikerya, 2020-05-13
@ikerya

strtotime('00:00:00')