Search results
These functions convert dates and times recorded as strings to Stata dates. Stata dates are numbers that can be formatted so that they look like the dates you are familiar with.
6 lip 2015 · See help datetime_translation under the section "the date function". If your dates are in v1 and in the form yyyy-mm-dd you can specify the commands: generate v2 = date(v1, "YMD") format %td v2. The YMD is called a mask, and it tells Stata the order in which the parts of the date are specified.
You can convert dates stored as strings to Stata dates by using the string-to-numeric conversion functions; see Converting dates stored as strings to Stata dates. You can make Stata dates readable by placing the appropriate %fmt on the numeric variable; see Formatting Stata dates for display.
Use a conversion function (F) Format the new variable. (B) Numerically encoded dates/times brought into Stata with import excel, import sas, or import spss will automatically be converted to Stata dates/datetimes.
Two commands, date and format, are used to convert a string date into a numeric date. Within these functions you will need to specify how the date-time information is formatted in the string. Use upper case for day, month, and year (e.g. “DMY”) but lower case if you want to specify hours, minutes or seconds (e.g. “DMYhms”).
Dates and time variables are best read as strings. You then use one of the string-to-numeric conversion functions to convert the string to an appropriate %t value: Format String-to-numeric conversion function %tc clock(string, mask) %tC Clock(string, mask) %td date(string, mask) %tw weekly(string, mask) %tm monthly(string, mask) %tq quarterly ...
17 gru 2015 · Below, we use functions for translating dates stored in string and numeric formats into a Stata date format. For details about converting dates from other software, see Using dates and times from other software. The two most widely used functions for translating string dates are date() and clock().
