Date difference in MySQL Oct25 '04

Feedback

# (1 of 3): Yegeswari

1 year, 11 months after the fact. (Wed 27 Sep 2006, 1:24 AM CST)

I found solution using this query. This site is very easy understand things. This is very userfriendly. I just added this site to my favourites.

regards,
yegeswari

# (2 of 3): Bhagwant

2 years, 8 months after the fact. (Tue 26 Jun 2007, 12:49 PM CST)

Well, Thanks to the site . I never knew what is the replacement of the dual of ORACLE in MySQL to test the in built functions of MySql

Well my purpose was to fetch the data from a table that is less then 8 days old.

SELECT field1, field2 FROM table_name WHERE DATEDIFF( now( ) , datefield ) >=8

THANKS AND Regards,

Bhagwant

Previous comment Return to entry

# (3 of 3): Joy » matthom

3 years, 11 months after the fact. (Wed 08 Oct 2008, 4:33 PM CST)

We've tried it, but the statement above are wrong!.........

Previous comment Return to entry

RSS feed for comments on this post

Leave feedback

Feedback

Input format: The editor controls below will assist with Markdown syntax.

Status

Sub-status

Your info Name: Email (will not show on page):

Follow new comments via email? (You can turn this off any time)

Do you want your comments emailed to yourself?

Home Page (optional):

Return to entry.

matthom is published and produced by Matt Thommes - an independent publishing enthusiast, mobile blogger, content creator, informative writer, web developer from Chicago. Never one to conform, Matt intends to promote the effect the web has on our lives, in an effort to intensify, instruct, and clarify all that is happening around us.

Contact Matt

Here’s a handy reference that uses MySQL to find the number of days between two dates.

You are at the feedback permalink page for: Date difference in MySQL