Display date in format DDMMYYYY

Question

Question

Jude Mukkadayil · Aug 9, 2023

#Key Question #ObjectScript #Caché #InterSystems IRIS

Hi,

Can anyone please help me to display date field in the format DDMMYYYY which I need single digit date needs to have leading 0 like 01022000.

I tried to-char but leading 0 is not there.

I am writing object script with the help of sql query for generating extracts.

can anyone please help on this.

thanks

jude

Product version: IRIS 2020.1

Discussion (19)3

Log in or sign up to continue

score 0 · Answer 1 · 2023-08-09T08:42:23-04:00

Ben Spead · Aug 9, 2023

Something like this?

USER>write $replace($ZDate($h,4,,4),"/","")
09082023

0 0

score 0 · Answer 2 · 2023-08-09T08:49:24-04:00

Or, to make it work for any international locale:

USER>write $replace($ZDate($h,4,,4),##class(%SYS.NLS.Format).GetFormatItem("DateSeparator"),"")
09082023

score 0 · Answer 3 · 2023-08-10T00:11:43-04:00

Hi Ben, This is not working fully. I mean to say MM is displaying with 0 but DD is not displaying with 0.

For instance, it displays as 1082000 and it should be 01082000.

Thanks

Jude

score 0 · Answer 4 · 2023-08-10T04:05:05-04:00

can you please show your actual variable being set and then your command and its execution? as you can see from my example above, I was able to get DD for a single digit day with 09 yesterday.

score 0 · Answer 5 · 2023-08-09T09:07:29-04:00

Julius Kavay · Aug 9, 2023

My favorit is

write $tr($zd($h,15),"/.")

0 0

score 0 · Answer 6 · 2023-08-09T12:02:14-04:00

Please see details on the yearopt parameter for $zdate (https://docs.intersystems.com/iris20232/csp/docbook/DocBook.UI.Page.cls?...) ... depending on the locale and on the year in question, if you don't specify yearopt you risk have a 2 digit year rather than a 4 digit year (default for my locale is yearopt = 0 which would show 20th century years as 2 digits). You probably want to specify a yearopt of 4 to force 4 digits all the time.

score 0 · Answer 7 · 2023-08-09T18:53:44-04:00

Using a two digit year in 2023 is the same as wishing to get a Y2K problem again. Probably it will be now the Y2.1K issue.

score 0 · Answer 8 · 2023-08-09T19:09:36-04:00

agreed - which is why I always recommend forcing 4 digit years using yearopt with $zdate() :) Keep in mind that $zdate() preceeded Y2K which is why is has behavior that defaults to 2 years in certain circumstances (to keep the API calls backwards compatible).

score 0 · Answer 9 · 2023-08-09T11:51:06-04:00

Pietro Di Leo · Aug 9, 2023

You can use:

w $ZSTRIP($ZDATE($NOW(),1,,),"*","/"),!

0 0

score 0 · Answer 10 · 2023-08-09T12:03:45-04:00

this would do mmddyyyy and not ddmmyyyy ... use 4 as your dformat instead (https://docs.intersystems.com/iris20232/csp/docbook/DocBook.UI.Page.cls?...)

score 0 · Answer 11 · 2023-08-09T12:13:15-04:00

Pietro Di Leo · Aug 9, 2023

You're right, this is the correct version

w $ZSTRIP($ZDATE($NOW(),4,,),"*","/"),!

0 0

score 1 · Answer 12 · 2023-08-09T12:21:53-04:00

Ben Spead · Aug 9, 2023

Yup - that works. Great use of $ZStrip!

1 0

score 2 · Answer 13 · 2023-08-09T14:19:29-04:00

What a night mare.

W $zd($h,15) =09/08/2023

w $zd($h,1)=08/09/2023

How do you know the which country the end user is in

08092023 is very bland

The Only international standard is used by the air lines

Imagine a ticket with such a date 08092023 this would be fraught with mis understandoing

w $zd($h,2,,4) = 08 Aug 2023 this is recognised the whole world over

hdate=$zdh(%d,2)

however
set Date=$tr($zd(%d,1),"/","") or
set Date=$tr($zd(%d,15),"/","")

depending on your calendar

score 0 · Answer 14 · 2023-08-09T18:54:55-04:00

A little longer, but far more flexible, I've always liked

write $translate("DdMmCcYy", "CcYy-Mm-Dd",  $zdate($now(), 3))

Just provide the format you want in the first argument.

score 0 · Answer 15 · 2023-08-10T00:44:21-04:00

Ramil TK · Aug 10, 2023

me is using this line to get this

w $ZSTRIP($ZD($NOW(),1,,),"*","/"),!

0 0

score 0 · Answer 16 · 2023-08-10T02:28:55-04:00

Can I see how you call TO_CHAR?
I have a leading zero displayed without problems:

SELECT %internal(to_date('01022000','DDMMYYYY')) -- 01022000 -> 58105
,TO_CHAR(58105,'DDMMYYYY') -- 58105 -> 01022000

TO_CHAR: Convert Dates to Formatted Date Strings

score 0 · Answer 17 · 2023-08-10T19:04:06-04:00

This is the way how I use to_char in sql statement

TO_CHAR(58105,'DDMMYYYY')

I am extracting the data to excel file and I can see the column is assigned as a General and not a number. does it make any difference ?

Thanks

score 0 · Answer 18 · 2023-08-11T01:39:46-04:00

It's clearer now, this is the tricks of Excel, which convert the string 01022000 to the number 1022000.
In your case, try changing the cell type from General to Text.

PS: when generating Excel reports, I use the Date cell type (short format DD.MM.YYYY), and from Caché/IRIS I return the %Date type.
The components that I use already know how to translate the internal representation of the date 01.02.2000 from the Caché/IRIS format (58105) to Excel (36557) and vice versa.

score 0 · Answer 19 · 2023-09-09T03:46:25-04:00

Developer Commu... · Sep 9, 2023

💡 This question is considered a Key Question. More details here.

0 0