>I have a character column in the database in this format:
>
>10:00 AM
>
>How can I get hour and minute from it?
>
>Thanks in advance.
>
>I found this RegEx pattern
>
>(1[012]|[1-9]):[0-5][0-9](\\s)?(?i)(am|pm)
>
>but how should I use it to get my groups?

This is what I came out so far - does it look correct?

String cRegEx = "(1[012]|[1-9]):[0-5][0-9](\\s)?(?i)(am|pm)";
MatchCollection matches = Regex.Matches("10:00 AM", cRegEx, RegexOptions.IgnoreCase);
foreach (Match m in matches)
         {
		   Console.WriteLine(m.Groups[0]);
            Console.WriteLine(m.Groups[1]);
			Console.WriteLine(m.Groups[2]);
         }