Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
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

2 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!!