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.
Hi ALE77 - This may help...to convert military time 13.89475 to standard time, follow these steps:
So, 13.89475 in military time converts to approximately 1:53:41 PM in standard time.
Thank you, that worked great!
Thank you, that worked great!
Be careful with methods that separate the hour calculation from the minute calculation.
E.g. 13.99, rounded to the minute, will translate to 1:00 PM instead of 2:00 PM, unless you specifically add logic to handle the minutes rounding "up" to :00.
*Community Hub is the new name for Sage City