钟悍

摘要： select date_part('minute', now() - create_date) from employee;update employee set issue_efficiency=date_part('days', issue_complete_date - review_pass_date)*3600*24+date_part('hour', issue_complete_date - review_pass_date)*3600+date_part('minute', issue_complete_date 阅读全文

摘要： create or replace function setPassengerType(num varchar) returns varchar as $$ declare sql varchar; str varchar; re record; begin str=''; sql = 'select passenger_type from tops_order.passenger where flight_order_item_id=''' || num ||''''; for re in execute... 阅读全文