[thelist] Oracle SELECT question !
rudy
r937 at interlog.com
Fri Jul 27 12:58:36 CDT 2001
> SELECT * From kestjori.vatnshaed_web
> WHERE TIEINS = '1'
> AND TIDTIM BETWEEN
> To_Date('01.01.2000') AND To_Date('27.10.2000');
hi óskar
your version of oracle probably has a different default format for
date strings (there's a *long* section in the oracle documentation
about the various formats you can use -- see
http://technet.oracle.com/doc/server.815/a67779/ch2.htm#34926
note: login required)
not sure about the installation default but i think it's DD-MON-YYYY,
e.g. 27-JUL-2001
all you have to do is either give your dates in the default format, or
just tell oracle which format you are using --
BETWEEN To_Date('01.01.2000', 'DD.MM.YYYY')
AND To_Date('27.10.2000, 'DD.MM.YYYY') ;
rudy
More information about the thelist
mailing list