Need some info with Proc sql in extracting date time field

[sasbasls]

HI,

I was getting this note in the log :

The data value for column  dat_time_field1 was truncated or was out of range 15 times when retrieving that

      data from the DBMS.

This looks to me that date time was not appropriately pulled into SAS dataset. Here back end d/b is Oracle.

Please let me know if any conversion for field needed to pull exact value from d/b.

thanks!

[Hima]

http://support.sas.com/kb/12/944.html

[jjwarr2]

This link does not work:

http://support.sas.com/kb/12/944.html

Can you please point me to the answer, either to where that KB article is now, or else where the answer is somewhere else?

[SASKiwi]

I think this is your problem:

http://support.sas.com/techsup/notes/v8/2/429.html

You should try running queries in an Oracle tool to verify if there are any dates outside the SAS date range.