'Retrieve hours and minutes with meridiem indicator (am/pm) in Oracle
I have hours and minutes in different columns like below
| Hour of Day | Minute of Day |
|---|---|
| 10 | 50 |
| 15 | 00 |
By using these values I need the exact day time like the result of above table should be
| Expected Result |
|---|
| 10:50 AM |
| 03:00 PM |
How can I achieve this by using Oracle or SQL? Can someone please help me onto this.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|