I am trying to create a query where Doctrine will select rows based on time difference determined by the value from a column.
There are these two columns:
diff (type=integer) – specifies number of minutes
start (type=datetime) – specifies starting time
Now I need a query that will select all rows where the time difference between the value in start column and actual current time is lower than number in diff column.
In other words the query should select all rows where date in start column is not older more than number of minutes in diff column.
Any kind of help would be appreciated.
Thanks a lot.
Source: Symfony Questions