ETL and Data Integration tools - Modern ETL software for everyone

Hi

I am using
insert into table (values)
select from tables

When I using to_char or without to_char its working fine from the toad or sql

rgds
jelson

Can you email us the screen shot so we can see the data

Mike

You are using wrong format
try using m/d/yyyy

Mike

I tried that already but its not inserting the date fields
pls find the screen shot and pls find the attached sql using to inserting the data
its working with toad and sql

Sorry I do not understand what is the problem

You only need to specify current format for source data our software does the rest.

Date field is stored in internal database format

The way you see it on the screen depends on you computer settings.

or are saying when you run this script in toad it does work in our software it does not?

yes when i running the same script its running fine in toad but its not running DB Software.

rgds
jelson