•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 426,810 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,924 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 408 | Replies: 5 | Solved
 |
•
•
Join Date: Apr 2008
Posts: 196
Reputation: 
Rep Power: 1
Solved Threads: 0
Junior Poster
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: 295
Reputation:
Rep Power: 1
Solved Threads: 41
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
Location: Sweet India
Posts: 828
Reputation:
Rep Power: 2
Solved Threads: 74
Practically a Posting Shark
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 1:41 am. Reason: add
Be intelligent, But Don't try to cheat.. Be innocent But Don't get cheated..
•
•
Join Date: Apr 2008
Posts: 295
Reputation:
Rep Power: 1
Solved Threads: 41
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 4: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.
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Previous Thread: Mysql Trigger error
- Next Thread: Do you have trouble connecting to mysql database using the odbc mysql 5.1 driver
