Currently have a passthrough query within MS Access that is used to extract data from an Oracle database.
Select Name, AdmitHr
from Encounter
Noticed that the query results for the "AdmitHr" field appears to be in military time format, i.e. 022, 17, 024, etc.
Can anyone offer insight as to how I can use the decode function to display the actual time - 2:00 pm instead of the military time?
Currently, using decode but thought that there is a more efficient method...
Thanks in advance.
Select Name, AdmitHr
from Encounter
Noticed that the query results for the "AdmitHr" field appears to be in military time format, i.e. 022, 17, 024, etc.
Can anyone offer insight as to how I can use the decode function to display the actual time - 2:00 pm instead of the military time?
Currently, using decode but thought that there is a more efficient method...
Thanks in advance.