How to convert AP Invoice Header, TimeUpdated field from Military time to Standard?

SOLVED

Hello, current theTimeUpdated field has values as 11.18964, 13.89475, 15.05072, .35896, looking to format in SQL as HH:MM AM/PM.  

Thanks.

Parents
  • +1
    verified answer

    Hi ALE77 - This may help...to convert military time 13.89475 to standard time, follow these steps:

    1. Separate the hours and the decimal part:
      • Hours: 13
      • Decimal part: 0.89475
    2. Convert the hours:
      • 13 hours in military time is 1 PM in standard time.
    3. Convert the decimal part to minutes and seconds:
      • Multiply 0.89475 by 60 to get the minutes: 0.89475 * 60 ≈ 53.685 minutes.
      • Separate the minutes and the decimal part: 53 minutes and 0.685 minutes.
      • Convert the remaining decimal part to seconds: 0.685 * 60 ≈ 41.1 seconds.

    So, 13.89475 in military time converts to approximately 1:53:41 PM in standard time.

Reply
  • +1
    verified answer

    Hi ALE77 - This may help...to convert military time 13.89475 to standard time, follow these steps:

    1. Separate the hours and the decimal part:
      • Hours: 13
      • Decimal part: 0.89475
    2. Convert the hours:
      • 13 hours in military time is 1 PM in standard time.
    3. Convert the decimal part to minutes and seconds:
      • Multiply 0.89475 by 60 to get the minutes: 0.89475 * 60 ≈ 53.685 minutes.
      • Separate the minutes and the decimal part: 53 minutes and 0.685 minutes.
      • Convert the remaining decimal part to seconds: 0.685 * 60 ≈ 41.1 seconds.

    So, 13.89475 in military time converts to approximately 1:53:41 PM in standard time.

Children