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.
