Re: SQL Concatenation

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 23 Sep 1999 18:44:56 GMT
Message-ID: <7sdsf8$fqm$8@news.seed.net.tw>

<amerar_at_ci.chi.il.us> wrote in message news:7s8do8$ka8$1_at_nnrp1.deja.com...
>
>
> Hello,
>
> The field I want to perform this operation on is of type DATE.
>
> I want to give the field a new MMDDYYYY while keeping the same hour and
> minute (HH24MI) from the date.
>
> Since when you put dates into the table you need the quote the string
> and provide a format, I'm not sure how to accomplish my above task. The
> month and day and year can be quoted, but the hour and minute will come
> from the existing value in that field.......
>
> any help would be appreciated.

for example,

update yourtable

set datefield = datefield - trunc(datefield) + to_date('09/24/1999', 'MM/DD/YYYY')
where .... Received on Thu Sep 23 1999 - 13:44:56 CDT