Ask the Expert

Control and fix date format problems on AS/400 SQL

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 first published in March 2009

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: