Re: Use of to_date function

[snip]
> BTW, your syntax specified isn't right:
> select datetime from a.view where datetime = to_date(
> '05-AUG-97 11:13:42');
> must be written as
> select datetime from a.view where to_char(datetime,
> 'dd-mon-yy hh:mi:ss') = ^^^^
> '05-AUG-97 11:13:42';

[snip]

Oops. Please appreciate my mistake!

-- 
                                                      ///
  Hiroshima '45   Chernobyl '86   Windows '95        (O O)
-------------------------------------------------oOO--(_)--OOo---------
  "There is more than one way to do it!"

(Remove -NOSPAM- from my email address)