The easiest way is to set the NLS_DATE_FORMAT as follows: ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS'
This will remain in effect for the remainder of this session or until it is set to another value. If you prefer a different format for the date string, see your Oracle reference manual. There are many options available. -dpf- ----------------------- David P. Fannin Database Administrator [EMAIL PROTECTED] UM-Rolla Computing and Information Services FAX (573) 341-4216 URL http://www.umr.edu/~dpf PHONE (573) 341-4841 ----------------------- -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 3:10 PM To: [EMAIL PROTECTED] Subject: Time component of Oracle timestamp field unavailable. Hello, My Oracle timestamp field returns only the date part when I select and fetch it. Is there any way to get the time as well? (DBI-1.25; DBD-Oracle-1.12; Oracle 8.1.7) Any suggestions/ideas would be appreciated. Paul.
