Modifying a Date Field
Modifying a Date Field
(OP)
How do I add a number of days/months/years to a date field.
e.g. in Access I can do the following:
Update [MyTable] set [mydate] = dateAdd('m', 2, [mydate])
This will add 2 months to all the [mydate] values.
How do I do something similar in Pervasive??
e.g. in Access I can do the following:
Update [MyTable] set [mydate] = dateAdd('m', 2, [mydate])
This will add 2 months to all the [mydate] values.
How do I do something similar in Pervasive??
Mighty
RE: Modifying a Date Field
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
RE: Modifying a Date Field
I simply did something like the following the following:
UPDATE "My Table" SET myDate = myDate + 365
Mighty
RE: Modifying a Date Field
Glad I could help. Thanks for the star.
Regards,
Tom