Hi All, I know that this issue is completely resolved, but let me offer a solution that might shed lights on future problems of sort: I had an oracle table (in a library called CRM) that I needed to insert some records using SAS . This is how I proceeded: first: got the data strucure of the table: 1) proc sql; describe table crm.open; answer in log: create table open ( EVENT_TYPE_ID num label='EVENT_TYPE_ID', ACCOUNT_ID num label='ACCOUNT_ID', LIST_ID num label='LIST_ID', RIID num label='RIID', CUSTOMER_ID num label='CUSTOMER_ID', EVENT_CAPTURED_DT num format=DATETIME22.3 informat=DATETIME22.3 label='EVENT_CAPTURED_DT', EVENT_STORED_DT num format=DATETIME22.3 informat=DATETIME22.3 label='EVENT_STORED_DT', CAMPAIGN_ID num label='CAMPAIGN_ID', LAUNCH_ID num label='LAUNCH_ID', EMAIL_FORMAT char(1) format=$1. informat=$1. label='EMAIL_FORMAT' ); 2) As you see, I have two variables that are of DateTime type, as Oracle keeps date in this formt. So I create tmy macro variable using DateTime function in SAS: %Let date_time=%sysfunc(compress(%sysfunc(datetime(),DATETIME22.3))); %let date=%sysfunc(date(), date9.); 3) Proceed to insert values, but make sure to use "dt" instead of "d" after macro variable. proc sql; insert into open2 values(4,3333,1111,.,&customer_id,"&date:00:00"dt,"&date_time."dt,1111,1111,'H'); insert into click2 values(5,3333,1111,0,&customer_id,"&date:00:00"dt,"&date_time"dt,1111,1111,'H','AAAAAA',0,'AAAAAA','AAAAAA'); ; quit; Conclusion: Even if you create correct date format as is the case with my macro variable date_time, you need to use it as "&date_time"dt to be able to insert in a right format. If you use "&date_time"d instead, you will get incorrect date , which is 01JAN1960:05:39:21.000 , instead of 30SEP2015:14:17:40.041, which is the intended value. And I don't think this is Oracle issue, I think it is sas issue and date time issue instead of date. Only in sas it reverts to 1960, not in Oracle. If you wnat to use date instead of datetime, then you will need to use @Tom's solution, which I have used in one of the field for matter of illustration. Hope this helps. Best, Araz
... View more