Re: A beginner's question

From: Guillaume Serre <guillaumeserre_at_hotmail.com>
Date: 2000/06/30
Message-ID: <8jhl7a$q98$1_at_nnrp1.deja.com>#1/1


In article <395a0de0_at_dnewserver.firstcom.cl>,   "Luis Aucañir" <laucanir_at_hotmail.com> wrote:
> Hi!
>
> Is valid the next expression?:
>
> SELECT *
> FROM Customer
> WHERE TRUNC(SchedStart) = TRUNC(SYSDATE);
>
> or is better this?:
>
> SELECT *
> FROM Customer
> WHERE TO_CHAR(SchedStart, 'DD-MM-YYYY') = TO_CHAR(SYSDATE,
> 'DD-MM-YYYY');
>

It's exactly the same, but I would expect TRUNC to be faster.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 30 2000 - 00:00:00 CEST

Original text of this message