AW: Create a field in AS/400 queries

["BirgittaHauser" <Hauser@xxxxxxxxxxxxxxx>]

Hi,

Just use the scalar function digits to convert numeric values into character
values with leading zeros:
NewField   Digits(MyYEAR) !! '-' !!
           Digits(MyMONTH) !! '-' !!
           Digits(MyDAY)

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them?  Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Silva Marco
Gesendet: Monday, September 10, 2007 19:43
An: Midrange Systems Technical Discussion
Betreff: Create a field in AS/400 queries


Hello

 

I have tree different fields in AS/400

Year

Month

Day

 

So I have this: 

2007

09

12

 

And I have to transform those tree fields in 2007-09-12. My problem is that
I can't concatenate because those fields are numbers.

 

I can I transform those number into a date?

 

 

Regards,

Marco