EST time calculation

Question

Hi,

 

   Let me know how to find

   1) Query to compare if time is prior to midnight EST 

   2) Query to compare if time is past to midnight EST

 

Thanks