User bio
404 bio not found
Member since Apr 4
Replies:

Yes, in the healthshare environment I am running the following script:

SELECT 
    id, 
    substr(TimeCreated, 12, 5) as HORA, 
    (DATEDIFF(ms, TimeCreated, TimeProcessed)) as TiempoTranscurrido ,
    TimeCreated as fecha,
    GETDATE() as hora_actual
FROM 
    ens.messageheader 
WHERE 
    SourceConfigName = 'HL7Filler HCIS'
    AND TimeCreated >= '2024-03-19 12:51:11.125'


I would like that in exchange for entering the exact time I could obtain it in the format, I have tried with the following script but it brings me the messages for that exact time and I need to bring all the logs in that time period "2 hours"

SELECT 
    id, 
    substr(TimeCreated, 12, 5) as HORA, 
    (DATEDIFF(ms, TimeCreated, TimeProcessed)) as TiempoTranscurrido ,
    TimeCreated as fecha,
    GETDATE() as hora_actual
FROM 
    ens.messageheader 
WHERE 
    SourceConfigName = 'HL7Filler HCIS'
    AND TimeCreated >= DATEADD(hour, -2, GETDATE())

 

Certifications & Credly badges:
Claudia has no Certifications & Credly badges yet.
Global Masters badges:
Claudia has no Global Masters badges yet.
Followers:
Claudia has no followers yet.
Following:
Claudia has not followed anybody yet.