Question 20508 in Mysql Question posted in
The official MySQL documentation can be found here.

How to compare now to a timestamp in Mysql, when greater than 1, else 0

How to compare now to a timestamp in Mysql, when valid_date is greater than now 1, else 0?

I only have data of valid_date, I need data of is_valid, thanks so much for any advice.

  valid_date   is_valid
  1675739460     0
  1680837060     1
  1678190564     1
  1686365124     1
Tags:

2

Answers


  1. 0

    You should be able to SELECT a boolean result by comparing the UNIX_TIMESTAMP() with valid_date.

    SELECT valid_date, UNIX_TIMESTAMP() < valid_date AS is_valid FROM table
    Login or Signup to reply.
  2. 0

    To compare a timestamp to the current time in MySQL, you can use the NOW() function, which returns the current date and time.
    To create a condition where valid_date is greater than NOW() – INTERVAL 1 DAY, you can use the following query:

    SELECT IF(valid_date > NOW() - INTERVAL 1 DAY, 1, 0) AS is_valid FROM table;

    You can adjust the time interval as needed by changing the value passed to INTERVAL.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search