Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Insert time into Oracle date field
Thanks Jim for your greate advice.
I am just wondering if it's possible to use insert statement to insert 13:27 into Oracle date field. Because my application was written in C++ and get time value from Unix OS.
Alan
"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message news:<5pxsc.111302$iF6.10141187_at_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 Tue May 25 2004 - 07:45:41 CDT