Yahoo Poland Wyszukiwanie w Internecie

Zaloguj się

Search results

  1. stackoverflow.com › questions › 2501915php - convert date string to mysql datetime field - Stack...

    Use DateTime::createFromFormat like this : $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.

  2. stackoverflow.com › questions › 8063057php - Convert this string to datetime - Stack Overflow

    The Problem is with your code formatting, inorder to use strtotime () You should replace '06/Oct/2011:19:00:02' with 06/10/2011 19:00:02 and date ('d/M/Y:H:i:s', $date); with date ('d/M/Y H:i:s', $date);. Note the spaces in between. So the final code looks like this. $s = '06/10/2011 19:00:02'; $date = strtotime ($s); echo date ('d/M/Y H:i:s', ...

  3. sebhastian.com › mysql-incorrect-datetime-valueHow to fix MySQL incorrect datetime value error | sebhastian

    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.

  4. www.slingacademy.com › article › how-to-convert-a-string-to-datetime-in-mysql-8How to convert a string to date/time in MySQL 8 - Sling Academy

    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.

  5. www.w3schools.com › SQl › func_mysql_convertMySQL CONVERT() Function - W3Schools

    29 sie 2017 · DATE. Converts value to DATE. Format: "YYYY-MM-DD". DATETIME. Converts value to DATETIME. Format: "YYYY-MM-DD HH:MM:SS". DECIMAL. Converts value to DECIMAL. Use the optional M and D parameters to specify the maximum number of digits (M) and the number of digits following the decimal point (D).

  6. dba.stackexchange.com › questions › 202627mysql - Incorrect value for str_to_date - Database Administrators...

    29 mar 2018 · STR_TO_DATE() returns a DATETIME value if the format string contains both date and time parts, or a DATE or TIME value if the string contains only date or time parts. This query, containing a date as well as a time part, does work:

  7. stackoverflow.com › questions › 2996370php - Converting string to datetime - Stack Overflow

    8 cze 2010 · The easiest way would probably be FROM_UNIXTIME (), but 1276142400000 does not appear to be a Unix timestamp: mysql> SELECT FROM_UNIXTIME(1276142400000); +------------------------------+. | FROM_UNIXTIME(1276142400000) |. +------------------------------+. | NULL |. +------------------------------+.