Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
find tax rates for current time period
drop table if exists vat; CREATE TABLE vat (id int auto_increment primary key, startdt date, enddt date, fullrate float, reducedrate float); INSERT INTO vat (startdt,enddt,fullrate,reducedrate) VALUES ('2000-01-01','2020-06-30',.19,.07), ('2020-07-01','2020-12-31',.16,.05), ('2021-01-01','2500-12-31',.19,.07); select * from vat where now() between startdt and enddt
run
|
edit
|
history
|
help
0
ITM_14210069
barbato
par
itm
MySQL : calculate overlapping periods
delivery_boy
ITM_14210069
probando la bd
MySQL JSON_SEARCH boolean Issue
Dynamic Pivot