ORACLE DATE TIME FORMAT HELP

[mikeyd]

I have a field in an ORACLE DB that has a date value of
5/10/2005 3:03:55 PM
When I run a normal php select statement it is only bringing back
5/10/2005
If I run the same select statement in VB it brings back the date and time...PHP keeps cutting the time off.

Can someone tell me why this is happening and where I can got to find out how to get the entire '5/10/2005 3:03:55 PM' back.
Thanks in advance for the help.

 

[mikeyd]

****Correction to the posting****

I have a field in an ORACLE DB that has a date value of
5/10/2005 3:03:55 PM
When I run a normal php select statement it is only bringing back
10-AUG-05
If I run the same select statement in VB it brings back the date and time...PHP keeps cutting the time off.

Can someone tell me why this is happening and where I can got to find out how to get the entire '5/10/2005 3:03:55 PM' back.
Thanks in advance for the help

 

[mikeyd]

I am such an idiot.
The data php is bring back for the date field is

10-MAY-05

Thanks for any help that someone can provide me in pulling back the entire date and time that is already in that field in the database.

 

[jpadie]

what is your php code for getting the data?

 

[mikeyd]

Thanks for the reply. I have now gotten it today.
I had a lowercase S in the alias for the field I was trying to pull.
I just could not tell it was lowercase until I replaced it.
Everything is working now. I had to use the To_Char with the correct format and a Good alias name to make it work.
Thanks again