基于日期的自动生成代码

Question

我想问如何基于production_date列生成批处理代码？

我的问题是：

SELECT  receiving_detail.con_id,   
         receiving_detail.ITEM_ID,      
         receiving_detail.TRANSACTION_QTY,   
         receiving_detail.UNIT_COST,  
         receiving_detail.UOM_ID,   
            item_master_list.item_code,  
            receiving_detail.po_item_id,
            receiving_detail.production_date,
            receiving_detail.expiration_date,
            receiving_detail.batch_code
    FROM receiving_detail   left join item_master_list on item_master_list.id=receiving_detail.item_id

预期产出：

con_id  ITEM_ID item_code   production_date expiration_date batch_code
413797  366     508246      2018-01-17       2018-07-17     180117
415012  108101  512761      2018-01-17       2019-01-17     180117
339027  27      301283      2017-09-19       2018-01-17     180117

Answer 1

SELECT  receiving_detail.con_id,   
         receiving_detail.ITEM_ID,      
         receiving_detail.TRANSACTION_QTY,   
         receiving_detail.UNIT_COST,  
         receiving_detail.UOM_ID,   
            item_master_list.item_code,  
            receiving_detail.po_item_id,
            receiving_detail.production_date,
            receiving_detail.expiration_date,
            convert(varchar, receiving_detail.production_date, 12) AS batch_code

    FROM receiving_detail   left join item_master_list on item_ma