[MySQL] Equivalent to MSSQL?[RESOLVED]

[john tindell]

Hey in MSSQL when i want to check a column to see if its older than five minutes i do

  DATEDIFF(minute,time_column,GETDATE()) <= 5

Is there an an equivalent in MySQL? or do i have to create the date in PHP and compare that value to the one in my DB?

Thanks

[mendhak]

No, DATEDIFF will return days.

I think you would need to use TIMEDIFF, SUBDATE or DATE_SUB to subtract and find the difference.

[mendhak]

Found it! Behold, my google skills:

http://dev.mysql.com/doc/mysql/en/da...functions.html

[john tindell]

Cheers, was searching for the wrong thing