bugs mysql STR_TO_DATE

 
1
0
-1

hi,

i found mysql bugs.

 im trying query select "select STR_TO_DATE('2022-02-16 10:24:36', '%Y-%m-%D %H:%i:%s')" 

but result is different "2022-02-16 00:24:36"


how to fix my problem?

mysql engine 5.7.33-0ubuntu0.16.04.1

thanks in advance


khafidz

    CommentAdd your comment...

    1 answer

    1.  
      2
      1
      0

      What is your desired result??
      Use %d instead of %D and you will get the hours 

      1. Muhammad Khafidz

        it work,

        thanks Anas

      2. Anas Misbah Shami

        You're welcome (smile)

      CommentAdd your comment...