Hi Neil, after some help from Aron Pilhofer and the online manual I got this statement
select (to_days(deadline)) - (to_days(current_date)) thanks!! K:) on 21/8/02 7:58 Uhr, Neil Mansilla at [EMAIL PROTECTED] wrote: > On Wed, 21 Aug 2002, Kai Vermehr wrote: > >> how can I calculate the difference between two dates in days? I'd like to >> get the days to go between <current_date> and a job-deadline in the future. >> >> thank)s to MySQL >> >> -- >> Kai Vermehr >> eBoy Graphics >> http://www.eboy.com > > Using a single MySQL select query to give me the date difference, I'd use > something like this: > > SELECT (UNIX_TIMESTAMP('2002-11-12')-UNIX_TIMESTAMP())/86400; > > Just performed that query and it gave me '82.96' -- so November 12, 2002 > is 82.96 days away. Of course, you'd substitute 2002-11-12 with something > more meaningful, such as your job-deadline date. > > Regards, > Neil Mansilla > whatUseek.com > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- Kai Vermehr eBoy Graphics http://www.eboy.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
