Hi! Please, how to insert current date via INSERT in a oracle table by SAS libname? This column is a date (data type, but have hours too) on oracle, and date9. (format and informat) on SAS. Im trying this: proc sql; INSERT INTO test (DET,DT_F,DT_I,ID_J,NM_J,QT_R,STAT,ST) VALUES(0,'',date(),8,'asdfghjkl',0,'qwertyuiop','zxcvbnm'); quit; But I got this error on "date()": ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, ), +, ',', -, MISSING, NULL, USER. ERROR 200-322: The symbol is not recognized and will be ignored. I need to insert current datetime in this field. Thanks a lot!
... View more