Ask Your Question
4

What is the SQL regular expression for the DDD:HH:MM format?

asked 2023-02-09 11:00:00 +0000

bukephalos gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
3

answered 2022-12-01 19:00:00 +0000

lalupa gravatar image

The SQL regular expression for the DDD:HH:MM format would be:

^[0-9]{3}:[0-9]{2}:[0-9]{2}$

This regular expression would match strings that start with three digits, followed by a colon, two digits, another colon, and two more digits.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2023-02-09 11:00:00 +0000

Seen: 8 times

Last updated: Dec 01 '22