Re: Update

From: Aparna <bliss_is_ignorance_at_hotmail.com>
Date: Wed, 5 Sep 2001 00:19:40 +0800
Message-ID: <3b950002.0@news.tm.net.my>

Hi,

Date fields in Oracle always store the date and time... While displaying only the date is displayed unless your select statement specifies otherwise... the max you can do is always store the time as 00 hrs by using trunc () e.g.

insert into tablename (datecolumn)

values (trunc (sysdate));

Hope this helps

Regards,
Aparna
"jop" <jop_at_novabase.pt> wrote in message news:5U2l7.57733$Fb.80595051_at_newsserver.ip.pt...
> I need help on SQL.
> I have a Date field that stores date and time. Now I want to have only
date.
> How to write an update SQL to update all rows with date only?
>
>
Received on Tue Sep 04 2001 - 11:19:40 CDT