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 wrote: > I just had cause to write the following, because it fit into the framework > slightly better than

[NF] Unusal WHERE clause

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',