How to correctly compare different date formats?

Question

MySQL

The date is stored in this format:

SQL query:

$period = 0;
        $time = time();
        
        switch ($data->filter) {
          case 'week': $period = $time - (60 * 60 * 24 * 7); break;
          case 'month': $period = $time - (60 * 60 * 24 * 30); break;
          default: $period = $time - (60 * 60 * 24); break;
        }
        
        $data = (object)[
          'user_id' => $data->userId,
          'period' => $period,
        ];
        
        $enrollments = $this->model->getEnrollments($data);


  public function getEnrollments($data) {
    $params = [
      'user_id' => $data->user_id,
      'period' => $data->period,
    ];

    return $this->db->row('SELECT id, amount, DATE_FORMAT(date, "%h:%i:%s %d.%m.%Y") as date FROM enrollments WHERE user_id = :user_id && status = 1 && FROM_UNIXTIME(date) > :period ORDER BY id DESC', $params);
  }

How to compare :period with date in db? ( :period - number, number of seconds since the beginning of 1970)
As you can see, I try FROM_UNIXTIME, but it doesn't work.
How to compare?

Answer 1

number of seconds since the beginning of 1970

It's called UNIX_TIMESTAMP. It may be necessary to take into account the correction for the time zone.

Answer 2

If you need to compare with the current time, then`date` > NOW()