Difference between following date time specifiers?

[qasdxx]

I have been playing around with the date time specifiers and am getting confused on how a few of them are different.

Specifically: 

What is the difference between %d and %m?

Per documentation, %d is the day of the month and %m is the month number. I get null values when trying to format a string to datetime object using %m.

What is the difference between %H and %k?

Per documentation, %H is hour in 24 hour clock and %k is 24 hours, leading zero is space. I get null values when trying to format a string to datetime object using %k. 

[apathetichell]

today's date is 2021-07-02 in Alteryx.

%d is day of the month (2)

%m is the month (7)

%H is hours (16 - where I am.).

%k is currently 16 - but 12 hours ago - it was 4 - %H was 04.

Try it with datetimenow() and datetimeformat(datetimenow(),"%H") or whatever you want to see the changes.

[Qiu]

@qasdxx 
The DateTime Function help files should have all we need.

https://help.alteryx.com/current/designer/datetime-functions