Re: DATES
From: Mark <lambicm_at_yahoo.com>
Date: Wed, 01 Jul 1998 11:18:58 +0100
Message-ID: <359A0D12.11B8_at_yahoo.com>
Date: Wed, 01 Jul 1998 11:18:58 +0100
Message-ID: <359A0D12.11B8_at_yahoo.com>
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) Received on Wed Jul 01 1998 - 12:18:58 CEST