'convert the data into readable format in sql
We have job schedule information in below format. Is there any SQL query that I can convert this into more useful format.
Current Format:
I am trying to convert into below format. Please let me know if any sql code that can convert to this format
| Job Name | is_daily | is_weekly | schedule_Days | Schedule_Hours | Next_Schedule |
|---|---|---|---|---|---|
| A | Y | N | Every Day | 7 PM | 30-03-2022 :07 PM |
| B | Y | N | Every Day | 7 PM, 9 PM ,10 PM | 30-03-2022 : 10 PM |
| C | N | Y | Mon | 8 PM | 30-04-2022 08 PM |
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|

