insert into t_equipment_efficiency_test_data(equipmentefficiencytestdataid,departmentid,equipmentid,furanceratedpower,netcalorificvalue,testdatetime,gasflow,ambienttemperature,exhausttemperature,oxygencontent,carbonmonoxide,sulfurdioxide,nitricoxide,antibalancefurnaceefficiency,carbondioxide,nitrogenoxide,grossfurnaceefficiency,netfurnaceefficiency,isdelete,createdatetime,lastupdatedatetime) values(4225711530261348352,2204290000000000001,2204290000001000001,1110,43000,to_timestamp('2023-09-22 17:09:00', 'YYYY-MM-DD HH24:MI:SS'),cast (nullif('24.6','') as float4),cast (nullif('29.5','') as float4),cast (nullif('69.7','') as float4),cast (nullif('13.52','') as float4),cast (nullif('','') as float4),cast (nullif('','') as float4),cast (nullif('','') as float4),cast (nullif('66.786346','') as float4),cast (nullif('','') as float4),cast (nullif('','') as float4),cast (nullif('86.1','') as float4),cast (nullif('94.9','') as float4),'f','2023-09-22 17:13:15.420','2023-09-22 17:13:15.420');
pgsql 通过sql语句插入空值
最新推荐文章于 2024-06-30 09:00:00 发布