Symfony Doctrine Query: SELECT ALL depending on time difference

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

Was this helpful?

0 / 0

Leave a Reply 0

Your email address will not be published. Required fields are marked *