Member Avatar for egvins

im pondering on some functions on MySQL especially on dates and times and i stumbled upon an idea where i can't find a predefined function that gets the next day of a specific day. For example: As of this post, the Date and Time is (GMT +8) : July 4, 2001 5:28PM - Monday. I want to find the next date when Monday will occur again. The answer should be: July 11, 2011. Anyone who could help me with this one?

  • 2 Contributors
  • 2 Replies
  • 96 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by egvins
Member Avatar for debasisdas

Try using DATE ADD()----add 7 days

and then use %W for mat to extract the day o use DAYNAME(date)

SELECT OrderId,DATE_ADD(OrderDate,INTERVAL 45 DAY) AS OrderPayDate
FROM Orders
Edited by debasisdas because: n/a
Member Avatar for egvins

thanks very much debasisdas...it really help me a lot :)

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.