var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to compare date times in a where clause
How do you express the following correctly?
select * from event where current year to minute - date_locked > 20 minutes
date_locked is a date time year to minute column in the event table. How do I express 20 minutes on the rhs?
The following appears to work:
Originally Posted by donpwinston
SELECT * FROM EVENT WHERE CURRENT YEAR TO MINUTE - date_locked > INTERVAL(20) MINUTE TO MINUTE;
Tags for this Thread