Re: [NF] Unusal WHERE clause

Boy, there was a time when I could spell "UnusUal". And this is Oracle SQL, but similar would probably work in whatever flavor you needed.

On Wed, Aug 2, 2023 at 9:37 AM Garrett Fitzgerald sarekofvulcan@gmail.com wrote:

I just had cause to write the following, because it fit into the framework slightly better than the procedural equivalent would have. It's code to clear out a hash table on a weekly basis to provide a delta export:

DELETE FROM ps_um_accom_std_hsWHERE to_char(sysdate, 'DAY') = rpad('SATURDAY', 9);

--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---