[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