How to get ICD9-code according to each timestamp for per patient?

[Blackzxy]

Is it possible to get ICD9-code with the timestamp for per patient? I notice we can only get ICD9_code with seq_num. However, there is no timestamp, I mean, just like that when this patient gets this ICD9_code in hospital.

[tompollard]

ICD-9 codes are assigned at the end of the hospital stay for billing purposes, so the timestamp that you are looking for isn't available. If you need to associate a timestamp with ICD codes, then perhaps the most appropriate timestamp to use would be the time of hospital discharge.