选择中的 MySQL datediff

Question

我有 2 个 mySQL 请求，我需要在我的第一个请求中包含我的 DATEDIFF 以显示 user_dateentree 但我不知道该怎么做..

SELECT poste_nom, ups_type_contrat, serv_nom, serv_id_resp 
     FROM USER 
     INNER JOIN USER_POSTE_SERVICE 
        ON USER.user_id= USER_POSTE_SERVICE.ups_poste_id  
     INNER JOIN POSTE 
        ON USER_POSTE_SERVICE. ups_poste_id = POSTE.poste_id 
     INNER JOIN SERVICE 
        ON USER_POSTE_SERVICE.ups_id_serv = SERVICE.serv_id 
     WHERE user_id = 2
        ORDER BY user_nom ASC

SELECT FLOOR( DATEDIFF( CURDATE( ) , user_dateentree ) /365 ) 
FROM USER

Answer 1

就这样

SELECT poste_nom, ups_type_contrat, serv_nom, serv_id_resp,
FLOOR( DATEDIFF( CURDATE( ) , user_dateentree ) /365 )  as 'datediff'
     FROM USER 
     INNER JOIN USER_POSTE_SERVICE 
        ON USER.user_id= USER_POSTE_SERVICE.ups_poste_id  
     INNER JOIN POSTE 
        ON USER_POSTE_SERVICE. ups_poste_id = POSTE.poste_id 
     INNER JOIN SERVICE 
        ON USER_POSTE_SERVICE.ups_id_serv = SERVICE.serv_id 
     WHERE user_id = :idSalarie 
        ORDER BY user_nom ASC