Scott Haneda wrote: >I am using 4.0.18-standard >So I do not have `DATEDIFF`, but I need to ability to do so, anyone know >some other simple trick to get days between two dates? > > to_days(SomeDate) - to_days(SomeOtherDate) will give you the number of days between the 2.
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]