Re: Date and DateTime columns

From: Dag Arne Matre <dag-arne_at_matreweb.com.antispam>
Date: Wed, 9 Jan 2002 11:35:56 +0100
Message-ID: <r_U_7.24243$KQ3.446094@news1.oke.nextra.no>

> trunc(date_column) = ...
>
> or specify a BETWEEN clause with time fraction 00:00:00 and 23:59:59
> (not having to specify this in every SQL-statement is probably what
> Dag Arne means by 'cleaner SQL') .
>

That is a perfect example of what I mean. Then add aggregate functions, group by, ...
Another factor for us is portability between dbms platforms. "where xxx_dt = :my_date" works on all platforms, while the other examples Jaap mentions might have to be written differently for each dbms platform.

D A Received on Wed Jan 09 2002 - 04:35:56 CST