mysqlvarchar轉(zhuǎn)年_mysqlvarchar類型轉(zhuǎn)datetime

2024年3月12日發(fā)(作者：摘抄好詞好句大全)

mysqlvarchar轉(zhuǎn)年_mysqlvarchar類型轉(zhuǎn)datetime

SELECT

p_id AS ship_warship_id,

record_id,

replace_time,

platform,

give_dept,

receive_dept,

AS record_remark,

id,

receive_time,

repair_time,

type_id,

cxdw_id,

_id,

AS ch_remark,

cxdw_name,

type_code,

type_name,

date_format(str_to_date(replace_time,'%Y-%m-%d'),'%Y.%m.%d') AS time_number

FROM

sys_warship ship

JOIN sys_replace_record record ON p_id = p_id

LEFT JOIN sys_ch_record ch ON _id = p_id UNION ALL

SELECT

p_id AS ship_warship_id,

record_id,

replace_time,

platform,

give_dept,

receive_dept,

AS record_remark,

id,

receive_time,