Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
glcordell
Contributor II
Contributor II

Convert Regular Time to Military Time

I have a date and time field with the time field in regular time (AM/PM). I want to convert the combination into military time. The date field is Service Date and the time field is Service.Service Start Time. Any help would be appreciated. Thanks in advance.

Labels (1)
1 Solution

Accepted Solutions
Taoufiq_Zarra

@glcordell  you can try :

TimeStamp(Timestamp#(RegularTime,'MM-DD-YYYY hh:mm:ss TT'),'MM-DD-YYYY hh:mm:ss') as MilitaryTime

 

for example :

Data:

load 
*,TimeStamp(Timestamp#(RegularTime,'MM-DD-YYYY hh:mm:ss TT'),'MM-DD-YYYY hh:mm:ss') as MilitaryTime
inline [
RegularTime
09-03-20 9:07:28 AM
];

output:

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

6 Replies
Taoufiq_Zarra

@glcordell  you can try :

TimeStamp(Timestamp#(RegularTime,'MM-DD-YYYY hh:mm:ss TT'),'MM-DD-YYYY hh:mm:ss') as MilitaryTime

 

for example :

Data:

load 
*,TimeStamp(Timestamp#(RegularTime,'MM-DD-YYYY hh:mm:ss TT'),'MM-DD-YYYY hh:mm:ss') as MilitaryTime
inline [
RegularTime
09-03-20 9:07:28 AM
];

output:

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
glcordell
Contributor II
Contributor II
Author

Thanks so much!!

human
Partner - Contributor II
Partner - Contributor II

do you get it in this form "2023-07-12T10:55:16Z"

With T as a sepperator or is this impossible?

BrunPierre
Partner - Master
Partner - Master

Do this.

Timestamp(Timestamp#(DateField, 'YYYY-MM-DDThh:mm:ssZ'), 'YYYY-MM-DD hh:mm:ss')

human
Partner - Contributor II
Partner - Contributor II

No, I mean transform it into this form. "2023-07-12T10:55:16Z" should be the end result. How has the format to be written that the result is in the form of "2023-07-12T10:55:16Z"?

BrunPierre
Partner - Master
Partner - Master

@human My bad, in that case perhaps this.

Date(Date#(RegularTime, 'MM-DD-YYYY hh:mm:ss TT'), 'YYYY-MM-DD') & 'T' & Time(Date#(RegularTime, 'MM-DD-YYYY hh:mm:ss TT'), 'hh:mm:ss') & 'Z' as FormattedDateTime