Date Format PHP Problem
DVAug 21 2008 — edited Nov 27 2008Hello,
I'm having a problem with this query that show at what time a responsibility was used.
SELECT DISTINCT
D.USER_NAME,
E.RESPONSIBILITY_NAME,
A.START_TIME,
A.END_TIME
FROM
FND_LOGIN_RESPONSIBILITIES A,
FND_RESPONSIBILITY B,
FND_LOGINS C,
FND_USER D,
FND_RESPONSIBILITY_TL E
WHERE
A.RESPONSIBILITY_ID = B.RESPONSIBILITY_ID
AND C.LOGIN_ID = A.LOGIN_ID
AND C.USER_ID = D.USER_ID
AND A.RESPONSIBILITY_ID = E.RESPONSIBILITY_ID
AND A.START_TIME > SYSDATE - 10
ORDER BY A.START_TIME
If I run it using PHP I have a problem with the Start Time and End Time. For these fields only the date is showed but not the time. It means that if a responsibility was used from 15.00 to 16.00 of the 20 August, the query will give in output Start Date 20-AUG-08 and End Date 20-AUG-08 but I wont be able to see at what time it was used.
If I run this query using an Oracle Client like SQL Developer everything is working fine and I will see Start Date 20-AUG-08 15:00 and End Date 20-AUG-08 16:00.
Any idea of how to solve the problem?
Thank you
BR