Re: Formatting timestamp date in MySQL

Hello, I just started with php and I'm also trying to format mysql date yyyy-mm-dd into mm/dd/yyyy. I looked through some books and they describe the use of DATE_FORMAT to covert the dates. Is there any other way to format the date? Thanks Alex My script looks like this: $month_1 = ($date_month_1); $day_1 = ($date_day_1); $year_1 = ($date_year_1); $month_2 = ($date_month_2); $day_2 = ($date_day_2); $year_2 = ($date_year_2); $query = "SELECT * FROM tablename where date >= '$year_1-month_1-$day_1-' AND date <= '$year_2-$month_2-$day_2'"; $result = mysql_query($query); $num_results = mysql_num_rows($result); echo "<p>Number of records found: ".$num_results."</p>"; for ($i=0; $i <$num_results; $i++) { $row = mysql_fetch_array($result); echo "<p><strong>".($i+1).". ID: "; echo ($row["id"]); echo "</strong><br>First name: "; echo ($row["fname"]); echo "<br>Last name: "; echo ($row["lname"]); echo "<br>Date: "; echo ($row["date"]); "Justin French" <justin@indent.com.au> wrote in message news:B8D927DC.3C52%justin@indent.com.au... > There is a difference between MySQL's timestamp, and a UNIX timestamp. > > strtotime(); is a really valuable tool -- converting almost any English date > description -- check out the manual for more info. > > Anyway, in this case, it is able to convert your MySQL date of 20020409 into > a unix timestamp, which is the required format for date() formatting. > > > In clear code: > > <? > > $date = "20020409"; > $date_unix = strtotime($date); > $date_f = date('jS M Y',$date_unix); > echo $date_f."<BR>"; > > ?> > > Although this can be condensed to: > > <? > $date = "20020409"; > $date_f = date('jS M Y',strtotime($date)); > echo $date_f."<BR>"; > ?> > > or even just > > <? > $date = "19770417"; > echo date('jS M Y',strtotime($date)); > ?> > > > Check out: > http://www.php.net/manual/en/function.date.php > http://www.php.net/manual/en/function.strtotime.php > > for more info and date() formats. > > > Note: I haven't done a heap of testing with strtodate() to ensure it's going > to return what you expect, but I randomly tested 10 dates in your format > between 1977 and 2002 without any problems. > > > Justin French > -------------------- > Creative Director > http://Indent.com.au > -------------------- > > > > > on 09/04/02 9:53 PM, nyon (ycnyon@pd.jaring.my) wrote: > > > Hi, > > > > I need to recall a date data in a MySQL database. > > The column is set as "date timestamp(8)". > > A sample of date is "20020409" > > > > I use the PHP Date function to format it back to say "9th April 2002". > > $date_formated = date($date, 'S M Y' ); > > However, it's still doesn't appear as formatted. > > > > Anyone mind sharing their code to do this? > > > > Nyon > > >