I have a database with dates in hourly format, and I need to transform them into daily format. Could someone please help me? Thank you in advance!
-
Login or Register
- Log in with
help datetime display formats
The formats for displaying Stata dates and times are Stata data type Display format ------------------------------------- datetime/c %tc[details] datetime/C %tC[details] date %td[details] weekly date %tw[details] monthly date %tm[details] quarterly date %tq[details] half-yearly date %th[details] yearly date %ty[details] -------------------------------------
clear set obs 5 set seed 128493 gen second = runiformint(0, 59) gen minute = runiformint(0, 59) gen hour = runiformint(0, 23) gen day = runiformint(1, 28) gen month = runiformint(1, 12) gen year = runiformint(1970, 2023) gen datetime = mdyhms(month, day, year, hour, minute, second) format %tc datetime list datetime
. list datetime +--------------------+ | datetime | |--------------------| 1. | 22jan2022 03:53:47 | 2. | 21mar1990 19:52:17 | 3. | 17mar1995 17:53:28 | 4. | 18aug2002 00:04:56 | 5. | 22oct2005 04:45:24 | +--------------------+
format %tcDD_mon_CCYY datetime list datetime
. list datetime +-------------+ | datetime | |-------------| 1. | 22 jan 2022 | 2. | 21 mar 1990 | 3. | 17 mar 1995 | 4. | 18 aug 2002 | 5. | 22 oct 2005 | +-------------+
Comment