Hi,
How can i pick next or prevoius day in mysql? Any function like curdate() ?
Thanks
veledrom
32
Master Poster
Recommended Answers
Jump to PostHi,
How can i pick next or prevoius day in mysql? Any function like curdate() ?
Thanksnext: today + 1
previous: today - 1
Jump to PostYou can do it with DATEADD, directly in MySql
SELECT DATEADD(...) AS IncrementedDate from ...
DATEADD("2000-12-01",INTERVAL 1 DAY)
All 5 Replies
tesuji
135
Master Poster
Shanti C
106
Posting Virtuoso
tesuji
135
Master Poster
veledrom
32
Master Poster
veledrom
32
Master Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.