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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DATEADD conversion
- Thread starter banccrop
- Start date
Hi Banccrop,
Have a look into the DATE and TIMESTAMP formats, and look into how you can perform arithmetic on them. This should lead you to the answer you are after.
This link describes in detail the arithmetic fucntions for dates and times in DB2 SQL.
Hope this helps
Marc
Have a look into the DATE and TIMESTAMP formats, and look into how you can perform arithmetic on them. This should lead you to the answer you are after.
This link describes in detail the arithmetic fucntions for dates and times in DB2 SQL.
Hope this helps
Marc
- Status