Thu, 24 Sep 2026
Login

bugs mysql STR_TO_DATE

Confluence User - 16 Feb, 2022

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

mysql;str_to_date

3

Confluence User •
16 Feb, 2022 •
confluenceUser •
1 •
confluenceUser •

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

Confluence User •
16 Feb, 2022 •
confluenceUser •
•
confluenceUser •

it work,

thanks Anas

Confluence User •
16 Feb, 2022 •
confluenceUser •
•
confluenceUser •

You're welcome (smile)

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
If you load & store in the section, what are the right steps to close the connection? load & store it into external database with JDBC Binder plugins and Custom datasource
Unable to import application with data on linux server
JDBC binder, error when connecting to external DB
Link 2 tables in one datalist
Security Violation (Code 403) behind SSL load balance
Unicode and Multiple Language storing in Joget
2 Joget apps using one db
In this Joget video tutorial, how do I reach an app's database with MySQL console?
How do I accomplish -a particular step, that I'll mention in the question's description- when trying to build the source code for Joget, on my computer?
Why do I get a "404 Not Found" error message when trying to reach the Joget Workflow app center?
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print