select rows based on exact time (hours, minutes and seconds)

Question

I want to update my wordpress posts based on exact time including hours, minutes and seconds, I tried the simple where clause, it seems ignoring the minutes and seconds, here is my simple query:

$date = '2023-05-16 07:28:31'; $res = $wpdb->get_results("SELECT ID FROM wp_posts where post_date = '".$date."'"); The result in this case return all the records with 2023-05-16

but I want only the posts with the exact time.

Answer 1

Try $date = '2023-05-16T07:28:31';