gmollineau

<div>
<div class="content wysiwyg-content fr-view">
HI<br><br>I have a AS400 BD2 data field representing a date - the format is yyymmdd, but the data type is numeric. <br>Example 1200228 is 28th Feb 2020.<br><br>I want to be able to have SQL recognize it as a date and substract 2 months from the date.<br><br>Example 1200228 - 2months should be 1191228 ..<br><br>Regards<br><br>Gerald
</div>
</div>



HI
I have a AS400 BD2 data field representing a date - the format is yyymmdd, but the data type is numeric.
Example 1200228 is 28th Feb 2020.
I want to be able to have SQL recognize it as a date and substract 2 months from the date.
Example 1200228 - 2months should be 1191228 ..
Regards
Gerald

How to use SQL to substract 2 months from BD2 data number 1200228

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.