SQL Convert European EUR date DDMMCCYY to DDMMYY
The following SQL is an example of how to convert a date such as 17041967 to 170467 create table myfile as ( SELECT ACCOUNTNR, datedmcy… Read More »SQL Convert European EUR date DDMMCCYY to DDMMYY
SQL – Convert Numeric Field to Date Type for Comparison
Many older databases have the dates held in numeric fields in formats such as ddmmyy. This can be problematic when performing selection and calculations. However, by… Read More »SQL – Convert Numeric Field to Date Type for Comparison
SQL Upper Case and Lower Case String Conversion
SQL Convert String to Upper Case postcode: cf64 3pg update customer set postcode = UPPER(postcode) postcode: CF64 3PG SQL Convert String to Lower Case postcode:… Read More »SQL Upper Case and Lower Case String Conversion
Validate a Legacy iSeries Date Using SQL
SQL is very useful for data hygiene projects allowing analysts to check the validity and integrity of the database. However, checking that a legacy date is correct cannot… Read More »Validate a Legacy iSeries Date Using SQL
Removing non-printable characters with RPG
Non-printable characters often find their way into the database. This often occurs due to EDI and manual copy/paste data entry from sources such as web-pages.… Read More »Removing non-printable characters with RPG