Re: A beginner's question

In article <395a0dbc$1_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');
>
> Thanks in advance,
> Luis Aucañir H.
> laucanir_at_hotmail.com
>
>

I prefer the second query to the first.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.