Re: SQL dates and numeric columns

On Tue, Sep 5, 2023 at 10:43 AM Dave <dfx1@xxxxxxxxxxxxxx> wrote:

I'm surprised it's still so difficult to get a date from a numeric value
Concat gives me this horrendous code :

date(

concat(

concat(

concat(trim(char(Y)), '-'), concat(trim(char(M)), '-')

)

, trim(char(D)))) " MyDate "

Don't use the CONCAT function. I agree, it's kind of silly that it
only accepts 2 parameters. Use the CONCAT operator. Anywhere that you
would have used the two vertical bars, use the word 'CONCAT' instead.
That's not necessarily the "best" way to do your date conversion, but
it is a way to preserve your original concatenation logic without
running into CCSID issues.

You can see the CONCAT operator in action in one of Birgitta's examples.

John Y.