DateTime from yyyy-mm-dd hh:mm:ss.000 to yyyymmdd

Question

Question

Krishnaveni Kapu · Jun 13

#Ensemble

how do I convert DateTime from yyyy-mm-dd hh:mm:ss.000 to yyyymmdd

Discussion (5)2

Log in or sign up to continue

Chris Stewart · Jun 13

Hi Krishnaveni

There are 2 answers to this. The easy but wrong way , and the more correct way

The easy way would be to take the piece of the string before the space character, and then remove all nonNumeric chars

set output = $ZSTRIP($PIECE(input," ",1),"*AP")

The better was is to convert to the canonical date format, then convert back to the format you want. Relevant documentation page: https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

set internaldate = $ZDATETIMEH(input,3)

set outputdate = $ZDATE(internaldate,8)

0 1

score 0 · Answer 1 · 2024-06-13T11:08:11-04:00

Krishnaveni Kapu · Jun 13

Thank you.

0 0

score 0 · Answer 2 · 2024-06-14T05:49:24-04:00

Krishnaveni Kapu · Jun 14

What if I need output in format - yyyymmddhhmmss

0 0

score 0 · Answer 3 · 2024-06-14T06:02:27-04:00

That time format isn't an inbuilt function for IRIS, so for this, you can adapt the string function above. Take the piece before the . (as your expected output doesn't include it), then strip all non numeric

set output = $ZSTRIP($PIECE(input,".",1),"*AP")

score 2 · Answer 4 · 2024-06-14T07:26:53-04:00

There's a good thread from a few years ago that goes into various ways of converting date formats which you can find here.

My approach in that thread was to suggest the use of the class method ##class(Ens.Util.Time).ConvertDateTime()

In your case using this option, you could do this for your main question:

Set Output = ##class(Ens.Util.Time).ConvertDateTime(input,"%Y-%m-%d %H:%M:%S.%N","%Y%m%d")

And then for your followup to include seconds:

Set Output = ##class(Ens.Util.Time).ConvertDateTime(input,"%Y-%m-%d %H:%M:%S.%N","%Y%m%d%H%M%S")