Search results
$date = DateTime::createFromFormat('m/d/Y H:i:s', $input_string.' 00:00:00'); $mysql_date_string = $date->format('Y-m-d H:i:s'); You can adapt this to any input format, whereas strtotime() will assume you're using the US date format if you use /, even if you're not.
30 lip 2016 · You can use MySQL's STR_TO_DATE function or you could use PHP's strtotime funciton. strtotime(date('Y-m-d H:i:s'));
23 paź 2021 · The obvious way to fix the error is to change the formatting of your value into the format that MySQL can accept. But rather than editing the value manually, you can use the STR_TO_DATE() function to help you convert the string value into date value.
26 sty 2024 · The most straightforward function for converting a string to a date or date/time in MySQL is the STR_TO_DATE() function. It takes a string and a format specifier and returns a formatted date: SELECT STR_TO_DATE('2021-04-30', '%Y-%m-%d') AS formatted_date; Output: 2021-04-30.
29 mar 2018 · I'm running a simple procedure that reads from a VARCHAR column and inserts data into a TIME column, using this format: STR_TO_DATE(vTestTime, '%H:%i'). I'm getting the error SQL Error (1411):
20 maj 2015 · Solution 1. You have to use Date.TryParse method [^], which provides a way to convert date using specific culture [^] (localization). or. You can convert date while getting data from MySQL server by using Date and Time functions [^].
How to use the MySQL STR_TO_DATE() function to convert a string into a date and/or time value with various practical examples.
