UPDATE a year from an ISO date field using SQL
Dear Sir/Madam, How can I update the year from a date field. For example the date file contains '2008-12-31' and I would like to use I-Series navigator's SQL to update the date field above with '2007-11-31'.But my intention for the update here is to decrease/deduct the year by 1 year and the month by 1 month as well as there could be thousands of different date which i cannot update one by one. The date field is in ISO format. Thanks and Best Regards, Kenny Ng
Software/Hardware used:
AS/400 I-Series navigator SQL
Software/Hardware used:
AS/400 I-Series navigator SQL
ASKED:
August 25, 2009 9:33 AM
UPDATED:
August 25, 2009 1:24 PM
RELATED QUESTIONS
- Ageing Report T-SQL
- Error: 'd.getElementById(...)'is null or not object(show in main web page)
- SQL select for month date range
- Plus signs in fields when using a date from a file compared to the month and year function
- Crystal Reports- displaying calculations for date range prior to date search parameter
Answer Wiki:
We need more specificity -- is your field a date type?
If the date that you have is a date type then I think this will work.
If you have a date in a char or numeric field then it needs more work.
Make a test file and try this. It should update all records in MyFile reducing MyDate
Update Myfile
Set MyDate = MyDate - 1 YEAR - 1 MONTH;
It should reduce the date by 1 year and to the same date one month before .. if the date exceeds the number in the month then the last day of the month.
Phil
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
