Excel formula and tricks

=YEAR(C2) & "-" & RIGHT("0" & MONTH(C2),2) & "-" & RIGHT("0" & DAY(C2),2) & " " & HOUR(C2) & ":" & RIGHT("0" & MINUTE(C2),2)

=YEAR(E2) & "-"&TEXT(MONTH(E2),"00") & "-" & TEXT(DAY(E2),"00") &" "&TEXT(HOUR(E2),"00") &":"&TEXT(MINUTE(E2),"00") &":"&TEXT(SECOND(E2),"00") &".000"