Q

Control and fix date format problems on AS/400 SQL

To avoid date format problems on the DB2 for iSQL interface, specify a date format that supports a four-digit year value with the DATFMT parameter in the SQL precompiled commands.

How can you set up AS/400 SQL to fix this query:
Select SDATE from Library/file 
  
DATE-HEADING 
11/01/39 
12/02/39 
+++++++ 
++++++++ 
++++++++ 
AS/400 SQL does not handle dates > 2039 
To eliminate this behavior, you must specify a date format (eg, *USA) that supports a 4-digit year value. Each DB2 for iSQL interface has a way to control the date format, for instance, the DATFMT parameter on the SQL precompiled commands.
This was last published in March 2009

Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close