By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
STR | CHECK_TIME(STR) |
---|---|
0 | 1 |
0:0 | 1 |
0:0:0 | 1 |
00:00:00 | 1 |
23:59:59 | 1 |
00:00:60 | 0 |
00:60:00 | 0 |
24:00:00 | 0 |
STR | CHECK_TIME(STR) |
---|---|
0 | 0 |
0:0 | 0 |
0:0:0 | 0 |
00:00:00 | 1 |
23:59:59 | 1 |
00:00:60 | 0 |
00:60:00 | 0 |
24:00:00 | 0 |
STR | VALIDATE_CONVERSION(STRASDATE,'FXHH24:MI:SS') |
---|---|
0 | 0 |
0:0 | 0 |
0:0:0 | 0 |
00:00:00 | 1 |
23:59:59 | 1 |
00:00:60 | 0 |
00:60:00 | 0 |
24:00:00 | 0 |