Formatting Date

faheem786

Hi there,

I want to display the date stored in mysql database in user readable format like (dd/mm/yyyy) etc..

My date is "1957-12-22" (the format of the fld in the db is date)

I want to display this similar to 22/12/1957 or 22 Dec 1957.

I used the following statement

<?= date("m/d/Y", strtotime($line['birth_date'] ))?>

I got an error as

Warning: date(): Windows does not support dates prior to midnight (00:00:00), January 1, 1970 :mad:

I'm going total mad on the dates. Pls help me with this question and also point me to some articles which easily explain me about date and the related things

Thanks
Ahmad

LordShryku

the manual explains this

faheem786

Hi..

Thanks but what's the alternative??

In ASP I used to format the dates with different options using formatdatetime function.

Is there any other function which can do this in PHP?

Also is there a function to extract the month, day and year values from a date like

1) Day (Date) 2) Month (Date) and 3) Year(date) ?

There might be functions already but I can't understand it because of the plenty of options which is difficult for me to find for the exact one I need

Thanks
Ahmad
Hong Kong

portaloo

always use your sql statement to get the date format of choice

$sql = mysql_query("SELECT topic, DATE_FORMAT(startdate, '%a %d %M %Y %h:%i:%s') as stdate, DATE_FORMAT(lastentrydate, '%a %d %M %Y %h:%i:%s') as ltdate FROM topic");

that will print out the date like this:

Mon 08 December 2003 06:32:40