Re: SQL Concatenation

From: <rspeaker_at_my-deja.com>
Date: Tue, 21 Sep 1999 21:01:21 GMT
Message-ID: <7s8rmq$vba$1@nnrp1.deja.com>

I'm not sure exactly what you are trying to accomplish, but it sounds like you want to extract the time portion of a stored date field and concatenate it onto a new date. If so, you may be able to accomplish what you want with the SUBSTR function of a SELECT statement. Check it out, it may help.

HTH,
Roy

In article <7s8do8$ka8$1_at_nnrp1.deja.com>, amerar_at_ci.chi.il.us wrote:
>
>
> 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.
>
> Arthur
> amerar_at_ci.chi.il.us
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 21 1999 - 16:01:21 CDT