We're moving

To all readers,

We apologize to the followers of this blog that support and updates on bsitpupt.blogspot.com will be discontinued. We are currently moving to a new site codersfriend.net. We also consider migrating existing posts here to the new site. This site will remain here for archive purposes only.

I would like to take this opportunity to thank you for spending some time in this website. I would like to encourage you to visit our new site, codersfriend.net and share your knowledge with us.

Thank you
jeremejazz

Mysql Date Calculation

Simple Function for Date Computation.. useful in archive retrieval

ADDDATE(date,INTERVAL expr type)
ADDDATE(date_field,INTERVAL 1 DAY)
ADDDATE(date,INTERVAL 2 DAY)
ADDDATE and SUBDATE perform date arithmetic calculations.

date is a DATETIME or DATE value specifying the starting date.
expr is an expression specifying the interval value to be added or subtracted from the starting date. expr is a string; it may start with a .-. for negative intervals.
type is a unit keyword indicating the units in which the expression should be interpreted.
Type Unit Expected Format
SECOND SECONDS
MINUTE MINUTES
HOUR HOURS
DAY DAYS
WEEK WEEKS
MONTH MONTHS
QUARTER QUARTERS
YEAR YEARS
Here we use the SUBDATE function to select products and their images added within the last month:

SELECT p.id, product_code, product_name, filename, date_added 
FROM product_tbl p 
INNER JOIN image_tbl i 
ON p.id=i.product_id 
WHERE date_added>SUBDATE(CURDATE(),INTERVAL 2 MONTH);

Source: Mysql Date Calulation - liamdelahunty.com

Computer Society in Tumblr

Check us out on tumblr.com

Computer Society

Android Ebooks

You can learn the basics android programming here :





for a hard copy of the book :

Turbo C/C++ Bundled

You can download a bundled Turbo C/C++ here...

Download TCP_Bundle

I've also configured it so that you won't have any problems with copying it to different directories :D

Sink the Bismarck

I have just updated the game I've been developing. It now comes with an animation.

Download v2