New post
Question
Ramyasri Kapalavai · Dec 31, 2020

Convert date and time into CCYYMMDDHHMMSS

#Caché #Ensemble #HealthShare

How to convert date and time into CCYYMMDDHHMMSS format??

For example the date and time format is 12/10/2019 21:41

0
1 458
Discussion (6)0
Log in or sign up to continue
Robert Cemper · Dec 31, 2020 

write $translate($zdt($h,8)," :")
20201231090429

0 0
Julius Kavay · Dec 31, 2020

If your input (date and time) format is the same as the example you provided,

set inpDateTime = "12/10/2019 21:41"

then use this one:

write  $tr($zdt($zdth(inpDateTime,1,2),8,1),": ")  --> 20191210214100

and if you want it "a little bit faster", the try this one

write  $tr("abcdefghijkl00","ef/gh/abcd ij:kl",inpDateTime)  --> 20191210214100

and you will get a speed gain of over 33%

Happy New Year!

(But this time, without Covid-19, if possible!)

0 0