MySQL gets yesterday data UTC time

# YZJ invited yesterday data select S.id, S.create_at, Ch.id, Ch.code as channel, C.id, C.code as Custom, So.id, So.code as Sourcefrom Invit E_ship sleft join Invite_channel ch on ch.id = S.invite_channel_idleft join Invite_code_custom c on c.id = S.code_custom_i Dleft JOIN invite_source so on s.invite_source_id = So.idwhere s.invite_source_id! = 0AND s.create_at > date_sub (date_s UB (Curdate (), INTERVAL 1 day), INTERVAL 8 HOUR) and S.create_at < Date_sub (Curdate (), INTERVAL 8 HOUR) ORDER by S.id DESC

Here S.create_at is the Time field, and if you have a UTC time in your library, this SQL logic is the right one.

MySQL gets yesterday data UTC time