Data Types in Teradata SQL

Posted on Oct 23, 2014 in Computer Science • Tagged with programming, Teradata SQL, data type, cast, date

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

** Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives. **

  1. It is important to …


Continue reading

Date Utilities in SAS

Posted on Sep 17, 2014 in Computer Science • Tagged with programming, SAS, date

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

Convert a Date to a String of the Format "YYYYMMDD"

data _null_;
    x = put("23Aug2014"d, yymmddn8.);
    put x date9.;
run;

or

data _null_;
    x = putn("23Aug2014 …

Continue reading

Time and Date in R

Posted on Nov 14, 2012 in Programming • Tagged with R, date, time, programming, CRAN

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

  1. The function as.Date and strptime convert string to dates. For these functions to work right, you must use the right format.