SYSDATE & TODAY() both not able to fetch today's date

[RDS2020]

Hi All,

I am trying to insert today's date into oracle table from SAS but getting error. How can we do this?

I am doing below:-

a. 

PROC SQL ;
insert into ORA.test
Select
SYSDATE,  OO.* from WORK.OUTPUT OO ;
QUIT;

Below is error i am getting:-

ERROR: The following columns were not found in the contributing tables: SYSDATE.

b.PROC SQL ;
insert into ORA.test
Select
today(),  OO.* from WORK.OUTPUT OO ;
QUIT;

Below 2 things happen:-

1. Sometimes it shows error saying:- invalid character ( because of brackets in today() )

2.And sometimes it enter "01/JAN/60" date into the oracle table.

Thanks 

RDS

[ChrisNZ · Accepted solution]

Please try:

insert into ORA.TEST 

select datetime(), * from WORK.OUTPUT ;

[RDS2020]

Hi Chris,
Thanks for reverting quickly. What is the reason behind sysdate and today() to not work and datetime() to work.
Regards,
RDS

[ChrisNZ]

sysdate is an oracle keyword, 

date() returns a date. Oracle usually stores date times.

Dates count days. Datetimes count seconds. Search the topic if you are unaware.