Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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)Received on Wed Nov 19 1997 - 00:00:00 CST