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
Only do a conversion using the proper mask for to_date. Utilize the NLS_DATE_FORMAT = 'YYYY-MM-DD hh:mi:ss'
Click Here to Expand Forum to Full Width