Jump to content

Days from date

- - - - -
Started by Nightracer, Sep 21 2006 02:05 PM

This topic has been archived. This means that you cannot reply to this topic.
2 replies to this topic

#1
Nightracer
Posted 21 September 2006 - 02:05 PM

Nightracer

    Programmer

  • Members
  • PipPipPipPip
  • 131 posts
If I have a date in mysql say 9-20-2006, is there a query I can run that will get the days since then until today?

#2
WingedPanther
Posted 22 September 2006 - 08:53 AM

WingedPanther

    A spammer's worst nightmare

  • Moderators
  • 16,831 posts
I believe you can use > and < in WHERE clauses on dates.
Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

#3
Void
Posted 22 September 2006 - 09:54 AM

Void

    Programming Expert

  • Members
  • PipPipPipPipPipPip
  • 411 posts
Use the TO_DAYS() function of mysql.

Example:

SELECT TO_DAYS(CURDATE()) - TO_DAYS(my_field) FROM tbl;

Void
Back to Database & Database Programming




  1. CODECALL Programming Forum
  2. → Web Development Forum
  3. → Database & Database Programming
IPB skins by Skinbox