Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Update
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
![]() |
![]() |