an issue with datetime

hi

defined a variable:

a = '02/15/2023 12:59:58';

did:

b = datetime(a,'InputFormat','MM/dd/yyyy hh:mm:ss')

i get:

15-Feb-2023 00:59:58

checked the time zone and also imposed the 'TimeZone' option.

thanks a lot !!!

mat

[Les Beckham]

What is your question?

datetime defaults to a 24 hour clock and 00:59:58 is the same as 12:59:58 AM. Since you didn't specify AM or PM, datetime is assuming AM.

[Shlomi Bejerano]

another example:

a = '02/15/2023 13:00:00';

datetime(a,'InputFormat','MM/dd/yyyy hh:mm:ss')

gives:

Unable to convert '02/15/2023 13:00:00' to datetime using the format 'MM/dd/yyyy hh:mm:ss'. ???

thanks

[Steven Lord]

Unable to convert '02/15/2023 13:00:00' to datetime using the format 'MM/dd/yyyy hh:mm:ss'. ???

That's correct. Looking at the table of letter identifiers in the documentation for the Format property of datetime objects the description of the 'hh' identifier is "Hour, 12-hour clock notation using two digits". On a 12-hour clock 13 is not a valid hour.

Now if you were to use "HH", whose description states "Hour, 24-hour clock notation using two digits", instead of "hh" then hour 13 is 1 PM.

a = '02/15/2023 13:00:00';
d = datetime(a,'InputFormat','MM/dd/yyyy HH:mm:ss')

d = datetime
   15-Feb-2023 13:00:00

If you want to show the AM/PM period, the identifier for that is 'a'. If I specify the period I probably also want to use the 12-hour clock so I changed "HH" back to "hh".

d.Format = 'MM/dd/yyyy hh:mm:ss a'

d = datetime
   02/15/2023 01:00:00 PM

Answer 1

[Voss]

Maybe you mean "HH"

a = '02/15/2023 13:00:00';

b = datetime(a,'InputFormat','MM/dd/yyyy HH:mm:ss')

b = datetime
   15-Feb-2023 13:00:00

[Shlomi Bejerano]

so simple.. thyanks alot !! :-)

[Voss]

You're welcome!