Re: A beginner's question

"Luis Auca ir" 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

Luis,

The easiest way is probably :

SELECT *
FROM Customer
WHERE SchedStart LIKE SYSDATE ;

That works fine (as long as you don't mess with the NLS DATE FORMAT setting for your SQL session...)

Regards
Steve Received on Fri Jun 30 2000 - 00:00:00 CDT