Extract date/time from oracle DB

[sumathikcs]

I am using perl scripts to receive the documents. For this i need to verify the received time. So, i need to extract a field with date/time from oracle db. the data type of the field format is date. For this i am using the below query

select <fieldname> from <tablename>

If i use the above query, i am getting date only.

I would really appreciate if i get help from anyone...

[miller]

If the data type is "date" and not "datetime" or "timestamp" why are you surprised that the query only is getting "date" information? This seems straight forward enough.

If this field doesn't contain time information, there isn't going to be any way to magic it into existance.

- Miller

PS
This might be an issue more appropriate for the Oracle Forum