This is a "log" table


This is the query result


B_TIME subtraction A_DATE and A_TIME combined with the result is null

This is my SQL code:
The select str_to_date (concat (A_Date, ' ', A_Time), '% % Y - m - h: % d % % I: % s') as the dd, Log_Id, B_Dept from ` logs ` ORDER BY dd

CodePudding user response:

The select str_to_date (concat (A_Date, ' ', A_Time), '% Y - m - % d % % H : % % s') as the dd, Log_Id, B_Dept from ` logs ` ORDER BY dd

Try this H caps

CodePudding user response:

On the top floor,
% H hours (00-23)
% h hours (01-12)