How to do split of column based on a delimiter in SQL

Asked Jul 07 '21 at 14:37

Active Jul 07 '21 at 14:53

Viewed 72 times

So i have a column with Values like

7AM
10:00AM
11:30AM
12:30PM
9PM

Can anyone tell me how achieve this type of output in sql

delimter should be used is ":"

output should be like below for the above input

7AM
10
11
12
9PM

so if you closely observe the inputs , there may be a case that delimeter wont exist

edited Jul 07 '21 at 14:53

sticky bit

asked Jul 07 '21 at 14:37

Shanmukh S

Which SQL engine do you use? – juergen d Jul 07 '21 at 14:39
Nothing specific , But i want to know which Method to use. Not able to find any – Shanmukh S Jul 07 '21 at 14:40
The answer totally depends on the engine. SQL dialects differ on MySQL, SQL Server, Oracle,... – juergen d Jul 07 '21 at 14:41
SQL Server to be specific. Thanks – Shanmukh S Jul 07 '21 at 14:42

0 Answers0