Need help with the SQL query

Hi Team,

Currently i have SQL query which will pull the current date records. But, now i have requirement to get the records that only created betweeen yesterday 2PM to current date… Can anyone help me the modification of query.

Currently using WHERE eb.createddate = Convert(Date, GETDATE(),110)

Regards,
Divya.

Hi, @divya.x.kuchi - Have a look on the below link