Comments
-
Got it thanks.
-
I came up with timestamp(CURRENT_DATE()-1)+(14/24) Let me know if you have anything better!
-
Fantastic Reply! thank you for the walkthrough and that should do it! Will let you knowif I have any questions but looks somewhat straightforward!
-
Worked a treat. thanks!
-
Ended up using this to be the 'last Thursday' part. Not sure if ther is a more elegant way for it but it does the job. case when DAYOFWEEK(CURRENT_DATE())=1 then CURRENT_DATE()-3 when DAYOFWEEK(CURRENT_DATE())=2 then CURRENT_DATE()-4 when DAYOFWEEK(CURRENT_DATE())=3 then CURRENT_DATE()-5 when DAYOFWEEK(CURRENT_DATE())=4…
-
Nevermind. seemed to work just like this: CONCAT(CURRENT_DATE(),' 12:00:00') Did not need the string part to compare to a date column.
-
Many thanks!