Re: Insert time into Oracle date field

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Tue, 25 May 2004 01:34:57 GMT
Message-ID: <5pxsc.111302$iF6.10141187@attbi_s02>

"Alan" <wangxianlg_at_yahoo.com> wrote in message news:18a6fc2f.0405241654.264a90a3_at_posting.google.com...
> Recently I try to migrate application from Unify database into Oracle.
> I came cross a problem. In Unify database there is time field which
> can store time value like 13:45. I am just wondering if it's possible
> to insert this time value into Oracle date field and how to insert it.
>
>
> Thanks in advance
>
> Alan

update statement

update mytab set myDateCol=to_date(to_char(myDateCol,'mm/dd/yyyy ')||myTimeCol||':00','mm/dd/yyyy hh24:mi:ss'))

Jim Received on Mon May 24 2004 - 20:34:57 CDT