>> B) SELECT * FROM some_table WHERE to_char(some_timestamp,
>> 'YYYYMMDD') >
>> to_char((now() - interval '1 day'), 'YYYYMMDD');
>
>I'd never use to_char to compare dates. The built-in comparison
>operators work just fine.
>
Why not? I'm curious if has anything to do with performance or just style?
Any difference between: ... WHERE to_char(my_date_col:date, 'YYYY.MM.DD') < '2007.06.07'
and ... WHERE my_date_col:date < '2007.06.07'
Is there a 3rd better way to do this comparison?