TalkPHP - View Single Post - How to covert the date into dd-mon-yyyy format?

sandhyagupta · 07-07-2009, 12:20 PM

Hi

I am fetching the date from a particular table. now i wanna convert that date into dd-mon-yyy(eg: 07-jul-2009)format before displaying it.How do i do this?

PHP Code:


			
$sql_stmt1 = "SELECT * FROM job_posting WHERE posted_by like '%$nickname%' ORDER BY job_posted_on DESC";



$result1  = mysql_query($sql_stmt1, $conn) or die(mysql_error());



while ($row1_array = mysql_fetch_assoc($result1))

{    

      $postedby = $row1_array["posted_by"];  

      $postid = $row1_array["post_id"];

      $position = $row1_array["position"];

      //echo '<a href="http://www.konanakunteokkoota.org/applyhereforjob.php?username='.$username.'&jobid='.$postid.'">'.$row1["position"].'</a>';  

  

      $joblevel = $row1_array["job_level"];

      

      $jobpostedon = $row1_array["job_posted_on"];

      //$convert1 = CONVERT(VARCHAR(11), GETDATE(), 106) AS [DD MON YYYY];

}

This is just the part of my code.

Thanks in advance.

07-07-2009, 12:20 PM	#1 (permalink)
sandhyagupta The Wanderer Join Date: Jun 2009 Posts: 20 Thanks: 4	How to covert the date into dd-mon-yyyy format? Hi I am fetching the date from a particular table. now i wanna convert that date into dd-mon-yyy(eg: 07-jul-2009)format before displaying it.How do i do this? PHP Code: $sql_stmt1 = "SELECT * FROM job_posting WHERE posted_by like '%$nickname%' ORDER BY job_posted_on DESC"; $result1 = mysql_query($sql_stmt1, $conn) or die(mysql_error()); while ($row1_array = mysql_fetch_assoc($result1)) { $postedby = $row1_array["posted_by"]; $postid = $row1_array["post_id"]; $position = $row1_array["position"]; //echo '<a href="http://www.konanakunteokkoota.org/applyhereforjob.php?username='.$username.'&jobid='.$postid.'">'.$row1["position"].'</a>'; $joblevel = $row1_array["job_level"]; $jobpostedon = $row1_array["job_posted_on"]; //$convert1 = CONVERT(VARCHAR(11), GETDATE(), 106) AS [DD MON YYYY]; } This is just the part of my code. Thanks in advance.