topic Re: Converting from AM/PM time to 24 hour time in App Development

Converting from AM/PM time to 24 hour time

jerryhelms2017 — Thu, 21 Jun 2018 15:13:37 GMT

My date fields are separated and the first step is to combine them. The code below works successfully.

EventDate,

StartTimeHour as ALT_StartTimeHour,

StartTimeMinute as ALT_StartTimeMinute,

StartTimeAM_PM as ALT_StartTimeAM_PM,

timestamp#(EventDate & ' ' & num(StartTimeHour,'00')

& ':' & num(StartTimeMinute,'00')

& ' ' & StartTimeAM_PM,'MM-DD-YYYY h:mm TT' ) as ALT_EventDate,

The output is in the AM/PM format, but I need the 24 hour format.

In a preceding load I have tried various timestamp and date functions. For example, the code below returns a null value.

timestamp#(ALT_EventDate,'MM-DD-YY h:mm') as ALT_EventDate2,

sunny_talwar — Thu, 21 Jun 2018 15:46:30 GMT

Try TimeStamp() instead of TimeStamp#()

TimeStamp(ALT_EventDate,'MM-DD-YY h:mm') as ALT_EventDate2,

YoussefBelloum — Thu, 21 Jun 2018 15:48:19 GMT

Hi,

referring to this link:

try Manish and Tresesco suggestions

TimeStamp(Timestamp#(ALT_EventDate,'DD/MM/YYYY hh:mm:ss TT'),'DD/MM/YYYY hh:mm:ss') as ALT_EventDate

SET TimestampFormat='DD-MM-YYYY hh:mm:ss[.fff]';

TimeStamp(Timestamp#(ALT_EventDate, 'DD/MM/YYYY hh:mm:ss TT')) as ALT_EventDate

jerryhelms2017 — Thu, 21 Jun 2018 16:12:39 GMT

I think the issue was that I was using '-' as a date separator as opposed to '/'. The solution from Youssef works.