存储过程、函数 单表更新、连表更新、获取六个月的最后一天。获取当月的最后一天

单表更新
update plant_psi_info
	set production = sales,
		production_amount = sales_amount,
		modify_by = p_user_id,
		modify_dt = hand_sys_now()	 	 	
	where
		org_id = p_org_id
		and psi_period = p_psi_period
		and del_flag = '0';			



 连另一张表更新
 update plant_psi_info
	set production = b.sales,
		production_amount = b.sales_amount,
		modify_by = p_user_id,
		modify_dt = hand_sys_now()
	from
		plant_psi_info b
	where
		b.org_id = p_org_id
		and b.psi_period = p_psi_period
		and b.del_flag = '0';			
		
		and plant_psi_info.org_id=b.org_id
		and plant_psi_info.uid=b.uid
		and plant_psi_info.user_id=b.user_id
		and plant_psi_info.row_num=b.row_num
		and plant_psi_info.inf_type=b.inf_type
		and plant_psi_info.m_code=b.m_code
		and plant_psi_info.psi_period =b.psi_period;

获取日期

select to_char(date_trunc('month',to_date((
select psi_period_st from plant_m_psi_period_info where org_id = 1 and psi_period = '2024年1月No.1'
),'yyyy-MM'::text) + ((seq_no-1)::varchar || ' month') ::interval) + interval'1 month - 1 day',
'yyyy-MM-dd') as shipping_dt from m_seq t2 where seq_no <= 6
		

执行结果

蓝色部分执行结果

获取当月的最后一天

select to_char((date_trunc('month',to_date('2024-05','yyyy-mm-dd')) + interval'1 month - 1 day'),'yyyy-mm-dd')