Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date Format PHP Problem

DVAug 21 2008 — edited Nov 27 2008
Hello,
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 25 2008
Added on Aug 21 2008
3 comments
6,494 views