DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DAte Conversion from informix to oracle

  1. #1
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159
    Hi,
    I am working on a migration of a informix database to oracle.I was stuck in a middle.I have a table called xxx with a column of datatype date and has values like

    2002-10-12 15:25:10(year/month/date/hour/min/sec).I need to copy this values to a oracle table which has a same column and datatype.I was working with sqlload and can any one tell me how to convert this values(with hour/min/sec) to oracle table.

    Waiting for ur reply
    Thanks

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Only do a conversion using the proper mask for to_date. Utilize the NLS_DATE_FORMAT = 'YYYY-MM-DD hh:mi:ss'

    Cheers

    Angel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width