Query report sales order creation time format not showing proper

[ravisingh001]

Helow sap team,

In sales order report in sap b1 its creation time format not comes proper its creation time format comes like 95:41:1

but real time format is 09:54:11 I sending you some screenshot for your reference please help me for finding the solution Asap.

[JoeyLi]

SAP B1 stores time values in a specific format, typically in the format of HH:MM:SS. In this format, the hour component (HH) should range from 00 to 23, the minute component (MM) should range from 00 to 59, and the second component (SS) should range from 00 to 59.

The time format "95:41:1" that you are seeing suggests that there might be a problem with the way the time value is being stored or displayed. It's possible that there is an issue with the data conversion or formatting settings in your SAP B1 system.

For example, lost the leading zero.

09 54 11 goes into 95411. Then it formats as 05:41:1.