To populate a date variable from something other than a literal string, you have to use the IBM-supplied%date BIF. If used with no parameters,%date will return the current system date. D myDate s d /free myDate =%date(); // myDate = *the current system date* *inlr = *on; /end-free If your dates come in one of the 12 standard formats all you need to do is indicate the field containing your date and the format it is in and the%DATE BIF does the rest.

Most of our dates are stored as YYYYMMDD in 8-byte numeric fields. This is the numeric version of the ISO format. Vlc free download for mac.

Keygen download windows 10. We can convert this to a date data type with the following code:%date(num_date: *iso) The '*iso' tells the%date BIF how my numeric date field (num_date) is formatted. We also have a few dates stored as MMDDYYYY in 8-byte numeric fields.

In this case all I change is the format on the%date BIF:%date(num_date: *usa) For anyone storing dates in alpha fields, the format you specify will depend on whether or not you store the date separators.

Using the same WITH values as @Fred, I came up with: WITH x(decvalue) AS ( VALUES (DECIMAL(1132009.00)),(DECIMAL(7152004.00)),(DECIMAL(11012005.00)) ) SELECT TO_DATE(CHAR(CAST(decvalue AS DECIMAL(8,0))), 'MMDDYYYY') FROM x This assumes that your input values aren't going to be longer than 8 digits (2 for month, 2 for day, 4 for year), otherwise you'll get an overflow error on the cast. It will also fail if there's not at least some value for each of month, day, and year ( 00002011 would not work, for example, but 01012011 would).

Re: sql dec to date convert SQL doesn't actually have a true 'date' type field like RPG. It creates dates from charactier fields. For example if 'MyDate' is a char field with '2008-02-12', you might have a function like this. Unit Converter NS needs a rating. Be the first to rate this app and get the discussion started! Unit Converter allows you to convert all of your units to all other unit types.