I have an oracle db table and I need to read a stored date and time from it into php.
When I am reading the values however all the times (althoguth they are different for each record) come back as 11, even though I am using TO_CHAR to convert them to the desired format. Also when I try to convert the date the same way, no date is read at all.
The sql statement is this:
"SELECT TO_CHAR(date,'dd-mm-yyyy'), TO_CHAR(time, 'HH12:MI'), from booking where id = '$id' order by date";
Any suggestions what I may be doing wrong?
Thanks!
