194416/convert-to-date-format-dd-mm-yyyy
I have the following date: 2010-04-19 18:31:27. I would like to convert this date to the dd/mm/yyyy format.
Hello @kartik, You can use STR_TO_DATE() to convert your strings ...READ MORE
The strtotime() function user manual doesn't give ...READ MORE
I have to use PHP to convert ...READ MORE
Hello, To convert a date retrieved from MySQL ...READ MORE
Hello @kartik, Try this: DATE_FORMAT(FROM_UNIXTIME(`user.registration`), '%e %b %Y') AS ...READ MORE
Hello @kartik, you can do SELECT STR_TO_DATE(yourdatefield, '%m/%d/%Y') FROM ...READ MORE
How can I convert one date format ...READ MORE
Use strtotime() and date(): $originalDate = "2010-03-21"; $newDate ...READ MORE
I want to put a copyright notice ...READ MORE
I am using PHP as the scripting ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.