Hi, I am having an issue converting what is assumably Unix time stamp to human readable time format.

* Example generated by -dataex-. For more info, type help dataex
Code:
clear
input long ORDER_TIME
205151
134137
145136
204606
211504
210942
212004
204921
205859
212712
202832
163404
212028
205544
142451
143439
155042
154539
180347
180922
180004
121746
142007
152555
162113
153127
171127
151331
161443
113412
131426
123955
123619
194452
150749
213547
131254
122751
125313
143205
171811
143902
140321
161717
140404
140210
140659
140311
213227
213112
212630
152042
153656
152006
152628
142653
140852
202313
201223
200808
144346
143442
145750
145629
151253
150323
153620
160810
154556
150338
152300
164043
191606
191427
174344
175629
180221
175809
135401
161011
160827
162033
163723
160521
 94127
165558
174701
193920
102503
182007
190233
165509
185454
184617
170928
140620
180016
180752
152800
164021
end
When I convert them using:

Code:
generate double statatime = ORDER_TIME*1000 + mdyhms(1,1,1970,0,0,0)

format statatime %tC

list ORDER_TIME statatime, noobs

the time window of the variable is in 1970s, where the actual time window is between 2019-2020.

I have searched through other threads regarding similar issues, and tried converting the ORDER_TIME variable to float,

Code:
recast float ORDER_TIME
but the results are way off from 2019-2020 time window.

So, at this point I am assuming that this might not be a Unix time stamp, or I have missed out something important converting them.

Array

Summarized ORDER_TIME has minimum value of 2, which I assume is not a valid Unix timestamp.

I'm starting to think that this might be some sort of time indicator of a day, but not sure what exactly it is indicating.

Can anyone provide advice on the matter?

Thanks in advance.