A beginner's question

From: (wrong string) ñir <laucanir_at_hotmail.com>
Date: 2000/06/28
Message-ID: <395a0de0_at_dnewserver.firstcom.cl>#1/1


Hi!

    Is valid the next expression?:

    SELECT *
    FROM Customer
[Quoted]     WHERE TRUNC(SchedStart) = TRUNC(SYSDATE);

or is better this?:

    SELECT *
    FROM Customer
[Quoted]     WHERE TO_CHAR(SchedStart, 'DD-MM-YYYY') = TO_CHAR(SYSDATE, 'DD-MM-YYYY'); Thanks in advance,
Luis Aucañir H.
laucanir_at_hotmail.com Received on Wed Jun 28 2000 - 00:00:00 CEST

Original text of this message