On Thu, 8 Aug 2002 17:16:31 -0500  "Nguyen, David M" <[EMAIL PROTECTED]> wrote:

> I try to read date/time from times_tamp column in my oracle database but I
> could not read it using SQL query.  Is it a way to resolve it?
> 
> SQL> select time_stamp from user_activity_log;
> 
> TIME_STAMP
> ----------
> 1.0220E+12

What does DESC say the type of that column is?  It looks like it might be
numeric or you might have assigned a format using the COLUMN command.
That is all SQL*Plus which is marginal on this list.

If you were fetching it with DBI and it is a DATE column, you'd either get
the default format (usually DD-MON-YY) or you'd need to wrap it in
TO_CHAR().

-- 
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.

Reply via email to