Good day. There are entries with date type. begin_registration and end_registration of the timestamp type. This is the registration period for the seminar. How to get all the entries for which registration is open. Those. Today is June 06, 2016, and the beginning of registration is from June 05, 2016 to June 21, 2016. How to write a SQL query correctly

  • Apparently something like SYSDATE between begin_registration and end_registration . Replace SYSDATE with the function that receives the current date of the desired type in your SQL dialect (which you did not specify in the question) - Mike
  • MySQL probably the function NOW - duddeniska
  • Well, yes, now() or curdate() (only date, no time) or current_timestamp() (you wrote something about the timestamp there). - Mike

1 answer 1

In postgresql

 SELECT * FROM tbl WHERE (begin_registration, end_registration) OVERLAPS ('2016-06-05':DATE, '2016-06-21'::DATE);