>>>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]);
>> }
>
>You could use DateTime.Parse to get a DateTime object instead. Easier to read and parse the values from.
Agreed. Avoid RegEx if it's not required.