Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Date

Date

From: Ralf Schnickmann <ralf_schnickmann_at_gmx.de>
Date: Fri, 12 Sep 2003 19:14:24 +0200
Message-ID: <bjsuo7$n3e7m$1@uni-berlin.de>


Hi!

The Query

    SELECT * FROM T_Test WHERE Start > '1.1.2002' is running with the correct results.

Using a date with time like

    SELECT * FROM T_Test WHERE Start > '1.1.2002 1:00:01' doesnt work.

My problem is that i have to avoid any function like to_date etc.

Thanks,
Ralf Received on Fri Sep 12 2003 - 12:14:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US