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
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