Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Modifying a Date Field 1
- Thread starter Mighty
- Start date
-
1
- #2
Hi,
I got this from the manual - hopefully it will help.
Regards,
Tom
Date Arithmetic
The SRDE supports adding or subtracting an integer from a date where the integer is the number of days to add or subtract, and the date is embedded in a vendor string. (This is equivalent to executing a convert on the date).
The SRDE also supports subtracting one date from another to yield a number of days.
Examples
SELECT * FROM person P, Class C WHERE p.Date_Of_Birth < ' 1973-09-05' and c.Start_date >{d '1995-05-08'} + 30
I got this from the manual - hopefully it will help.
Regards,
Tom
Date Arithmetic
The SRDE supports adding or subtracting an integer from a date where the integer is the number of days to add or subtract, and the date is embedded in a vendor string. (This is equivalent to executing a convert on the date).
The SRDE also supports subtracting one date from another to yield a number of days.
Examples
SELECT * FROM person P, Class C WHERE p.Date_Of_Birth < ' 1973-09-05' and c.Start_date >{d '1995-05-08'} + 30
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question