 |  |  |  |  |  |  |  |
How to pick next or prevoius day?
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
•
•
Join Date: Apr 2008
Posts: 490
Reputation: 
Solved Threads: 0
Posting Pro in Training
Hi,
How can i pick next or prevoius day in mysql? Any function like curdate() ?
Thanks
How can i pick next or prevoius day in mysql? Any function like curdate() ?
Thanks
•
•
Join Date: Apr 2008
Posts: 296
Reputation:
Solved Threads: 42
Posting Whiz in Training
•
•
•
•
Originally Posted by veledrom 
Hi,
How can i pick next or prevoius day in mysql? Any function like curdate() ?
Thanks
next: today + 1
previous: today - 1
Information is moving—you know, nightly news is one way, of course, but it's also moving through the blogosphere and through the Internets. I promise you I will listen to what has been said here, even though I wasn't here. Ann and I will carry out this equivocal message to the world. I'm the master of low expectations.
•
•
Join Date: Jul 2008
Posts: 1,071
Reputation:
Solved Threads: 98
You can do it with DATEADD, directly in MySql
SELECT DATEADD(...) AS IncrementedDate from ...
DATEADD("2000-12-01",INTERVAL 1 DAY)
SELECT DATEADD(...) AS IncrementedDate from ...
DATEADD("2000-12-01",INTERVAL 1 DAY)
Last edited by Shanti Chepuru; Jul 26th, 2008 at 2:41 am. Reason: add
Be intelligent, But Don't try to cheat.. Be innocent But Don't get cheated..
•
•
Join Date: Apr 2008
Posts: 296
Reputation:
Solved Threads: 42
Posting Whiz in Training
hi velodrom
may also give some results.
krs, tesu
sql Syntax (Toggle Plain Text)
may also give some results.
krs, tesu
Last edited by peter_budo; Jul 26th, 2008 at 5:17 pm. Reason: Keep It Organized - please use [code] tags
Information is moving—you know, nightly news is one way, of course, but it's also moving through the blogosphere and through the Internets. I promise you I will listen to what has been said here, even though I wasn't here. Ann and I will carry out this equivocal message to the world. I'm the master of low expectations.
 |
Other Threads in the MySQL Forum
- Previous Thread: Mysql Trigger error
- Next Thread: Do you have trouble connecting to mysql database using the odbc mysql 5.1 driver
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm data database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier journalism keyword keywords kickfire laptop law legal license licensing linux managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns resultset saas select sharepoint simpledb single sourcecode spotify sql sugarcrm syntax table techsupport thunderbird transparency virtualization
