Regex for hh:mm:ss tt string

Question

I've looked at a few regex time questions but haven't found one that I need and I'm pretty clueless on how to write regex expressions.

I need time values like this to pass:

This regex seems like it'd work for this(which I found on Here but I also need to have the AM/PM part required but it can also be case insensitive.

([0-1]?\d|2[0-3]):([0-5]?\d):([0-5]?\d)

So to sum up what I need in this regex:

Any help would be greatly appreciated.

@AaronBertrand - These times will be saved into a SQL server. I have a different part of the program which sets the current time with a button, so I didn't need any regex there, but I also need to allow for editing of times in back end. — D.Galvez, Jul 02 '12 at 17:21

zellio · Accepted Answer · 2012-07-02T17:25:13.983

2

The regex you provide supports 24 hour time, the following my stringently follows your request

(1[012]|0?\d):[0-5]?\d(:[0-5]?\d)?\s+[AaPp][Mm]?

edited Jul 02 '12 at 17:25

answered Jul 02 '12 at 17:19

zellio

Working great, does that final ? at the end make the am/pm optional? – D.Galvez Jul 02 '12 at 17:35
It makes the [Mm] optional, so that AM/PM can be added as A or P – zellio Jul 02 '12 at 18:20

Igor Chubin · Answer 2 · 2012-07-02T17:26:30.770

1

Just add ? after the seconds part and \s+[aApP][mM] at the end of the re:

([0-1]?\d|2[0-3]):([0-5]?\d)(:([0-5]?\d))?\s+[aApP][mM]

And when you don't neet 24h format change the first part:

(1[0-2]|0?\d):([0-5]?\d)(:([0-5]?\d))?\s+[aApP][mM]

edited Jul 02 '12 at 17:26

answered Jul 02 '12 at 17:17

Igor Chubin

They said no military time, which I'm going to assume means they are american and mean 24 hour clock. – zellio Jul 02 '12 at 17:20
@Mimisbrunnr - Sorry about that, I've edited my question to clarify that. – D.Galvez Jul 02 '12 at 17:24

2 Answers2