Hi Statalisters,

I have had issues with converting a date variable which was imported from database in clock data type into daily. Here is a sample of the data:

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input double year_of_birth
1.9039428e+12
1.9039428e+12
1.9039428e+12
1.9039428e+12
1.9039428e+12
1.9039428e+12
1.9039428e+12
1.9066212e+12
1.9066212e+12
1.9066212e+12
end
format %tc year_of_birth
I have tried with
Code:
format %td year_of_birth
list
But the data changes to numbers


Code:
    year_o~h    
        
1.    1.90e+12    
2.    1.90e+12    
3.    1.90e+12    
4.    1.90e+12    
5.    1.90e+12    
        
6.    1.90e+12    
7.    1.90e+12    
8.    1.91e+12    
9.    1.91e+12    
10.    1.91e+12
Any suggestions to get the time variable into daily (YMD) will be appreciated

Madu