Re: DATES

In article <359A0D12.11B8_at_yahoo.com>, lambicm_at_yahoo.com wrote:

>Linda Harte wrote:
>> One application inserts sysdate into a table
>> insert into table1 (the_date) values (sysdate)
>
>If you just want to insert the date, without a time, replace sysdate
>with TRUNC(sysdate)
>
>> select * from table1 where the_date =
>> to_char('01-07-1998','dd-mm-yyyy')
>
>If you want to select a date from a column which has the time stored,
>without selecting the time, replace the_date with TRUNC(the_date)

You may also use the TRUNC(SYSDATE) on the insert value list. The TRUNC is very flexible.

-- 
lorenzen_at_tiny.net             | Life is complex; it has
                              |   real and imaginary parts