[TYPO3-english] Time comparison

Sergio scatala at iti.upv.es
Mon May 11 17:47:53 CEST 2009


Hi list, 

Would you know how to convert field "crdate" on a content to SQL time
format? 

I would like to do something like this to know what the last content
items were 5 minutes ago:

SELECT uid, title, crdate
FROM tt_content 
WHERE crdate >= SUBTIME(SYSDATE(), "0 0:5:0.0000000")

but time formats are different in the comparison. 

Thanks in advance, 
Sergio



More information about the TYPO3-english mailing list