Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> A beginner's question
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