SQL Query Help!

[cycle]

Bro’s i want to pull the count of all the records from a particular column which are not in 24hrs format.

Also have to pull if i have records as 25:00,26:00 etc

example: i have to pull which are 6:00, 5:00,4:00 etc

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Skip

 

 

valid format is 06:00, 05:00, 04:00

Appreciate  your Help

[isthri_chembu]

Explore function REGEXP_LIKE

[cycle]

9 minutes ago, isthri_chembu said:

Explore function REGEXP_LIKE

Tried bro not working.

Tried with 
select * from TableName where REGEXP_LIKE (ColumnName,'([01]?[0-9]|2[0-3]):[0-5][0-9]');
 

[dasari4kntr]

Can u try this?

^([0-1][0-9]|[2][0-3]):([0-5][0-9])$

[cycle]

6 minutes ago, dasari4kntr said:

Can u try this?

^([0-1][0-9]|[2][0-3]):([0-5][0-9])$

Thanks a lot bro. Working

[2020]

 Nenu Chaala nerchukovali