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
practicee
W
Comparación de Collations general-spanish-latin en MySQL
Lanaldiak
gandu
sree..
index
mysql - where (between)
Dx
ritesh