Error in Date column

[Helannivas]

My source file for eg.

DOB

28/10/1988

25/10/1988

I am loading into target table.I am getting the same o/p in SAS DI.(Right click on target table in sas DI job and open).

But,When I check in oracle database,Its showing the o/p as

DOB

01-Jan-1960

01-Jan-1960.

What we we need to do?Pls help

[LinusH]

Is the target Oracle?

It seems that your source data is in date format, and the target is datetime. Check the data type in oracle, the SAS format applied to it. There are also some options that handles date/datetime conversions between SAS and oracle.

[Helannivas]

Yes,my target in oracle database.

My source s in flat file and extracted as character datatype in sas DI and

i checked my target column (DOB) is in date format in oracle.

I have tried some fncs ,its not workin..

[LinusH]

Make sure that you have date. format on the last table (and on the target table) for DOB.

If that does not help, try to play with the dbtype= data set option.

http://support.sas.com/documentation/cdl/en/acreldb/65247/HTML/default/viewer.htm#p1dqaq7ub1cm1pn1ow...

[CTorres]

You can also try the SASDATEFMT Data set option:

SAS/ACCESS(R) 9.3 for Relational Databases: Reference, Second Editio