Use "Yesterday before 2pm" in a case statement

colinr

Hello all!

 

I'd like to use "yesterday at 2pm" in a case statement.  How do I write out that condition?

 

The case statement would look a bit like this.

 

Case when 'date' < "Yesterday at 2pm" then 'yes' else 'no' end

Appreciate any help.

colinr

I came up with 

 

timestamp(CURRENT_DATE()-1)+(14/24)

Let me know if you have anything better!

colinr

I came up with 

 

timestamp(CURRENT_DATE()-1)+(14/24)

Let me know if you have anything better!