Hi I was playing around with the intnx function... data _null_;
_datetime='25MAR2020:23:31:45.052348'dt;
second_b = intnx('second',_datetime,0,'b');
second_e = intnx('second',_datetime,0,'e');
put _datetime e8601dt26.6;
put second_b e8601dt26.6;
put second_e e8601dt26.6;
run; I got the following output 2020-03-25T23:31:45.052348
2020-03-25T23:31:45.000000
2020-03-25T23:31:45.000000 But I was expecting something different for the end of the second, like .999999 instead of .000000 2020-03-25T23:31:45.052348
2020-03-25T23:31:45.000000
2020-03-25T23:31:45.999999 Did I miss something here? Best Regards, Véronique
... View more