On 1/6/06, Brian Dunning <[EMAIL PROTECTED]> wrote: > > On Jan 5, 2006, at 9:38 PM, Michael Stassen wrote: > > > DATEDIFF was added in 4.1.1. What version of mysql do you have? > > Thanks Michael - that was indeed the problem. Some ancient-ass > version that's been on my development server for who knows how many > years, in accordance with the "If it ain't broke don't fix it" rule. > > :)
Without using DATEDIFF I would suggest subtracting the current UNIXTIME from the UNIXTIME of meets.creation and converting the resulting number of seconds back to days. -jp
