Posted By

vasdee on 11/25/08

Tagged

date
format

Versions (?)

Last Edited at 11/25/08 08:41pm

Statistics

Viewed 1459 times

Favorited by 0 user(s)

Related snippets

Converting SAS datetime to oracle_datetime

/ Published in: SAS

Annoyingly hard to find, I'm sure others out there have felt the pain of converting sas dates to oracle date formats.

example:
data _null_;
x_dt = datetime();
x_d = date();
put x_dt oracle_datetime.;
put x_d oracle_date.;
run;

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

proc format library=your.formats.library;
  picture oracle_datetime other='%0d/%0m/%0Y %0H:%0M:%0S' (datatype=datetime);
run;
 
proc format library=your.formats.library;
  picture oracle_date other='%0d-%0b-%0Y' (datatype=date);
run;
 
proc format library=your.formats.library;
  picture oracle_time other='%0H:%0M:%0S' (datatype=time);
run;