RE: How does one cast a time field into a 2 byte character field?

Try the following:

VarChar_Format(Current_Timestamp, 'HH24MI')

Mit freundlichen Grüßen / Best regards

Birgitta Hauser
Modernization – Education – Consulting on IBM i

IBM Champion since 2020

"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!"
"Train people well enough so they can leave, treat them well enough so they don't want to. " (Richard Branson)
"Learning is experience … everything else is only information!" (Albert Einstein)

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of a4g atl
Sent: Wednesday, 14 June 2023 20:17
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: How does one cast a time field into a 2 byte character field?

Thank you

On Wed, Jun 14, 2023 at 1:59 PM Peter Dow <petercdow@xxxxxxxxx> wrote:

Shorter version:

substr(char(current_time),1,5)
''

On 6/14/2023 10:38 AM, a4g atl wrote:

I am trying to cast a time field into a 2 byte character field.

HOUR(Current TIMESTAMP) || ':' || CAST(Minute(Current Timestamp) as

Char(2).

The result drops the leading zero example if the time is 5 minutes
past

7,

the result shows as 7:2 instead of 7:02.

I am using this in a script.

DIGITS does not work here.

How can I do this?

TIA, Darryl Freinkel.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.