Files
opensourcepos/app/Database/Migrations/sqlscripts/3.3.2_paymentdatefix.sql
2024-06-15 17:19:15 +02:00

4 lines
182 B
SQL

UPDATE `ospos_sales_payments`
JOIN `ospos_sales` ON `ospos_sales`.`sale_id`=`ospos_sales_payments`.`sale_id`
SET `ospos_sales_payments`.`payment_time`=`ospos_sales`.`sale_time`;