Re: Update

From: Norbert <usun_to.norbert_at_exbud.com.pl>
Date: Tue, 4 Sep 2001 14:33:54 +0200
Message-ID: <9n2hno$q7j$1@news.tpi.pl>

try TRUNC() function

update tablename set date_time_field = trunc(date_time_field) where condition;

Norbi

>
> jop <jop_at_novabase.pt> schrieb in im Newsbeitrag:
> 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 - 07:33:54 CDT