topic Re: SYSDATE & TODAY() both not able to fetch today's date in SAS Programming

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

RDS2020 — Fri, 17 Jul 2020 06:00:54 GMT

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:-

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 — Fri, 17 Jul 2020 06:15:28 GMT

Please try:

insert into ORA.TEST

select datetime(), * from WORK.OUTPUT ;

RDS2020 — Fri, 17 Jul 2020 06:17:56 GMT

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

ChrisNZ — Fri, 17 Jul 2020 06:26:30 GMT

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.