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

Home -> Community -> Usenet -> c.d.o.tools -> A beginner's question

A beginner's question

From: Luis Aucañir <laucanir_at_hotmail.com>
Date: 2000/06/28
Message-ID: <395a0da9$1@dnewserver.firstcom.cl>#1/1

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 Received on Wed Jun 28 2000 - 00:00:00 CDT

Original text of this message

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