ansaurus

Question

Convert date format from mysql TIMESTAMP help

Answer 1

+2 A:

Something like this might help:

$date = date( "j F", strtotime( $row[insert_date] ) );
$display_table .= "<td width='67' rowspan='2'>$date</td>";

Rudisimo 2009-10-17 21:30:30

how about swedish dates? october in swedish is oktober... is there a simple way to solve this?

Camran 2009-10-17 21:38:53

@camran - Set the locale before performing the query: "SET lc_time_names = 'sv_SE';"

Mark 2009-10-17 21:45:39

update to my last comment, that is assuming you are using my solution posted, not Rudisimo's

Mark 2009-10-17 21:46:20

is there a way to check if a letter in the script you gave me rudismo, has a value...?example: if $date = october then = oktober?

Camran 2009-10-17 21:54:07

@Rudisimo, that functionality is already built in to PHP with strftime(): http://php.net/manual/en/function.strftime.php. I feel the my mysql solution is simpler however as it negates the need for all of these php function calls

Mark 2009-10-17 21:56:31

Answer 2

+1 A:

An alternative to Rudisimo's answer is making mysql do the work for you:

SELECT DATE_FORMAT(`insert_date`,'%d %M') AS insert_date FROM `table_name` WHERE [...]

Mark 2009-10-17 21:41:17

please explain more about this... Im currently using fetch array in a while loop for my table... give me some hints please

Camran 2009-10-17 21:56:39

You just need to add the following into your SQL statement: "DATE_FORMAT(`insert_date`,'%d %M') AS insert_date". That will override the value for $row[insert_date] with a formatted version of the date. You won't need to adjust anything else in your php code

Mark 2009-10-17 22:01:05

Answer 3

A:

you can set the language using locale and then use the mysql date_format or php strftime()

heres a website that will help you format the date http://www.mysqlformatdate.com

gerard 2010-01-12 19:43:15

ansaurus

tags:

views:

answers:

Convert date format from mysql TIMESTAMP help

related questions