Hi Stata Users,

I have a numeric date variable in the data ex below, and I need to split it into two different variables, date var, and time var.
this is what I have where the date here is year-month-day-hour-minute:

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str11 produkt_code int sdo_id double zeitstempel float wert byte(qualitaet_niveau qualitaet_byte)
"TT_TU_MN009" 1103 2.01601e+11  2.3 7 6
"TT_TU_MN009" 1103 2.01601e+11  2.8 7 6
"TT_TU_MN009" 1103 2.01602e+11  8.5 7 6
"TT_TU_MN009" 1103 2.01602e+11    9 7 6
"TT_TU_MN009" 1103 2.01603e+11 -1.6 7 6
"TT_TU_MN009" 1103 2.01603e+11 19.6 7 6
"TT_TU_MN009" 1103 2.01603e+11 15.4 7 6
"TT_TU_MN009" 1103 2.01604e+11 15.1 7 6
"TT_TU_MN009" 1103 2.01605e+11  9.8 7 6
"TT_TU_MN009" 1103 2.01605e+11  8.6 7 6
"TT_TU_MN009" 1103 2.01605e+11 17.1 7 6
"TT_TU_MN009" 1103 2.01607e+11 24.7 7 6
"TT_TU_MN009" 1103 2.01608e+11 15.5 7 6
"TT_TU_MN009" 1103 2.01608e+11 15.3 7 6
"TT_TU_MN009" 1103 2.01609e+11 16.9 7 6
"TT_TU_MN009" 1103  2.0161e+11   14 7 6
end

this how I need it to be.

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str11 produkt_code int sdo_id double zeitstempel long zeitstempel_1 str4 zeitstempel_2 float wert byte(qualitaet_niveau qualitaet_byte)
"TT_TU_MN009" 1103 2.01601e+11 20160101 "0:00" 2.3 7 6
end


I could have used this code but I have hours and minutes, maybe that's why it did not work:
Code:
 gen mydate = date(zeitstempel, "mdyhm")  
 format mydate %d
Thank you all