settlementid

    1. select DATE_FORMAT(now(),'%Y%m%d120000')as A
    2. from dual;