 |  |  |  |  |  |  |  |
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: 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,076
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 |
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for MySQL
"use" 1 agplv3 alfresco amazon api artisticlicense aws bizspark changingprices communityjournalism contentmanagement contractors copyright count crm data database design developer development distinct drupal dui ec2 eliminate email enter enterprise error facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip join journalism keyword kickfire laptop legal license licensing linux maintenance mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource operand oracle pdf penelope php priceupdating query referencedesign remove results saas select sharepoint simpledb sourcecode spotify sql statement sugarcrm techsupport thunderbird update virtualization
