Re: Problems combining a date and a character time field

From: Tom Zamani <tomz_at_redflex.com.au>
Date: Wed, 5 Apr 2000 10:24:23 +1000
Message-ID: <8ce1h1$bf6$1_at_perki.connect.com.au>

select to_char(sysdate,'DD-MM-YYYY HH24:MI:SS') from dual; TO_CHAR(SYSDATE,'DD

---

05-04-2000 10:17:12
eg
if your time format is HH24:MI:SS then
to_date(TO_CHAR(date_field,'DD-MMM-YYY') ||Time_fld),'DD-MM-YYYY HH24:MI:SS')

Tom

Barry <barryw_at_gmisystems.com> wrote in message news:8cdtee$39c$1_at_nnrp1.deja.com...
> I'm having problems combining a Date field with a Time which is
> stored in a varchar2(10) field to make an integrated Date field.
> I've tried things like TO_CHAR(date_field,'DD-MMM-YYY') || Time_fld
> which looks alright in a 'SELECT' but refuses to INSERT INTO a Date
> field.
>
> I'd appreciate any suggestions.
>
> TIA
>
> Barry
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Apr 05 2000 - 02:24:23 CEST