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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DDS field data type date

Status
Not open for further replies.

LUEBBKEVIN

Programmer
Apr 30, 2002
35
0
0
US
Someone asked me why they couldn't specify a field as a date in their DDS. I don't recall.....HELP
 
One consideration is null field processing. You need to use the ALWNULL keyword on the field in DDS and use RPG4's %NULLIND BIF to set the null indicator on or off. Unless, that is, you don't mind '01-01-0001' as a default date.

Where I work, we use 7-byte CYYMMDD fields for dates. I wrote some modules to do the conversion to or from 6 or 8 byte numeric fields for displaying and printing. "Don't worry about the world coming to an end today. It's already tomorrow in Australia."
--Charles Schultz

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top