Re: SQL latest greatest way to convert char mm/dd/yy to numeric yyyymmdd

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Jay

I assume what you posit, that the original is character.

Here's an SQL solution, as you requested:

select dec(date(timestamp_format('01/02/96', 'mm/dd/RR'))) from 
sysibm/sysdummy1;

This is dependent on the OS version - needs to be 7.3, I believe - the 
RR in the format string compensates for which half century the "year" 
value is in.

You can use "yy" instead, but that uses the 1st 2 digits of the current 
year. You'd have to subtract 1000000 from the result, maybe.

HTH
Vern

On 4/26/2019 10:13 AM, Jay Vaughn wrote:
> seems there is always a new way to skin a date format conversion...
> looking for the cleanest way to convert a date such as...
> '01/02/96' to 19960102
>
> tia
>
> jay