| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Dates
"Roger Smith" <rsmith22_at_fastmail.net> wrote
> I need to physicaly change a date to the first of every month ex:
>
> 12/31/2000 to 12/1/2000 and so on
>
> select RealDate, (Changed RealDate) as NewDate
> from ...
>
SELECT TRUNC(date_item,'MONTH') from table_name;
Received on Tue Oct 21 2003 - 15:24:37 CDT
 |
 |