General information
Category:
Coding, syntax & commands
Title:
Date manipulation question
It's been a hectic day in two differnt RDBMS apps, so forgive the silly question, I'm nearing brain dead.
I need to batch update a group of records. There are two date field, start_date, end_date. Start_date is easy, it gets DATE() or a user selected date as a value. End_date, however needs to be EXACTLY 10 years later. DATE()+3650 does not account for leap years, nor does DATE()+3653, allthough it works for this year. Is there a quick way to add 10 years? I have been looking through the help files and cannot find a reff to adding years, only minites, sec, hours and days.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only