today() to insert into date format of Oracle table

[SASAna]

Hi SAS users,

A filed "ENTRY_DT" is built as date format in Oracle Database, i am trying to load current date in YYYY-MM-DD format .

I tried to convert it into character with put function & also input function. still getting te below error, where it is inserting the records into table.

ENTRY_DT = put(today(),YYMMDD10.);

ERROR: ENTRY_DT, a numeric column, can only be updated with a numeric expression.

Thanks,

Ana

[Tom]

Just assign the date value to the variable.  What format you use to display a date does not change the value that is stored in the SAS dataset (or ORACLE table).

entry_dt = today()

[SASAna]

Hi Tom,

Jus loading today() in the entry_dt field is giving resulsts like "1/1/1960 time".  I wanted them to be "YYYY- MM-DD" format & also todays date

[Tom]

Sounds like you have DATETIME field instead of DATE field.  What happens if you use DATETIME() function or DHMS(today(),0,0,0) instead?

[Patrick]

Please post your full code of how you want to load this date value into Oracle.

Be aware that a DATE column in Oracle maps to a SAS DateTime value (and NOT a SAS Date value) and though the value to load should be datetime().

http://support.sas.com/documentation/cdl/en/acreldb/69580/HTML/default/viewer.htm#p06jk0u30uhuj5n18f...

If you're interacting with Oracle then make yourself also familiar with:

http://support.sas.com/documentation/cdl/en/acreldb/69580/HTML/default/viewer.htm#p0f64yzzxbsg8un1uw...

...and with:

options sastrace=',,,d' sastraceloc=saslog nostsuffix;

http://support.sas.com/documentation/cdl/en/engfedsrv/70118/HTML/default/viewer.htm#n167fxh8cc9h2an1...

[SASAna]

Hi Tom,

I tried DATETIME()  :

data enter;

FORMAT ENTRY_DT DATETIME20.;
ENTRY_DT = DATETIME();

run;

I am getting full date and time being printed in the tables. (12/19/2016 12:39:26 PM) I want it to be YYYY-MM-DD format. Table has Date format for this variable ENTRY_DT.

Thanks,

Ana

[Tom]

If you want SAS to display only the date part of your datetime values you can use the DTDATE format instead of the DATETIME format.

If you to store only the date part of the current datetime time then store DHMS(TODAY(),0,0,0) instead of DATETIME().

[Peter_C]

Does the wrong presentation come from oracle or SAS ?