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
Kurro Lopez · Dec 31, 2020 Hi, Have a look this link https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls?KEY=RC... Best regards, Kurro Lopez Ramyasri Kapalavai · Jan 4, 2021 Thankyou Lopez.. Robert Cemper · Dec 31, 2020 write $translate($zdt($h,8)," :")20201231090429 Ramyasri Kapalavai · Jan 4, 2021 Thankyou Robert 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!) Ramyasri Kapalavai · Jan 4, 2021 Thankyou Julius.. Happy New year !
Ramyasri Kapalavai · Jan 4, 2021 Thankyou Lopez.. Robert Cemper · Dec 31, 2020 write $translate($zdt($h,8)," :")20201231090429 Ramyasri Kapalavai · Jan 4, 2021 Thankyou Robert 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!) Ramyasri Kapalavai · Jan 4, 2021 Thankyou Julius.. Happy New year !
Robert Cemper · Dec 31, 2020 write $translate($zdt($h,8)," :")20201231090429 Ramyasri Kapalavai · Jan 4, 2021 Thankyou Robert 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!) Ramyasri Kapalavai · Jan 4, 2021 Thankyou Julius.. Happy New year !
Ramyasri Kapalavai · Jan 4, 2021 Thankyou Robert 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!) Ramyasri Kapalavai · Jan 4, 2021 Thankyou Julius.. Happy New year !
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!) Ramyasri Kapalavai · Jan 4, 2021 Thankyou Julius.. Happy New year !
Hi,
Have a look this link
https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls?KEY=RC...
Best regards,
Kurro Lopez
Thankyou Lopez..
Thankyou Robert
If your input (date and time) format is the same as the example you provided,
then use this one:
and if you want it "a little bit faster", the try this one
and you will get a speed gain of over 33%
Happy New Year!
(But this time, without Covid-19, if possible!)
Thankyou Julius..
Happy New year !
Social networks
InterSystems resources
Log in or sign up
Log in or create a new account to continue
Log in or sign up
Log in or create a new account to continue
Log in or sign up
Log in or create a new account to continue