Re: Help with SQL statement and SUBSTR

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 30 Sep 2005 16:43:23 +0200
Message-ID: <vkjqj1d6i7pikk7ch6hhgvsvmhnuhk5l2h@4ax.com>

On 30 Sep 2005 07:23:26 -0700, norcold1_at_yahoo.com wrote:

>I've alse tried date formats such as:
>TO_CHAR(PCH.INSERT_DATETIME,'MM-DD-YYYY HH24:MI:SS') > '09-29-2005
>00:00:00' and TO_CHAR(PCH.INSERT_DATETIME,'MM-DD-YYYY HH24:MI:SS') <
>'09-30-2005 00:00:00'
>
>'****
>
>What do I need to do differently? I imagine it might have something to
>do with the order in which Oracle is executing the statment.

The to_char is required around the hardcoded literal. The order of execution has nothing to do with it.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Sep 30 2005 - 09:43:23 CDT