[SOLVED] sql query for date

[pixeltrace]

guys,

 

i need help, i have a field in my database

 

date_posted (date) 0000-00-00

 

what should be in my query if i wanted just to get the value of the day?

 

let say

 

			<?
		$uSql = "SELECT date_posted(i just wanted to get the day) FROM dates";
		$uResult = mysql_query($uSql, $connection);
		if(!$uResult){
		echo 'no data found';
		}else{
		while($uRow = mysql_fetch_array($uResult)){
			?>

 

whats the correct query for this?

thanks!

[Jessica]

you can do it in php using strtotime() and date() or use mysql date_format:

http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html

[mmarif4u]

guys,

 

i need help, i have a field in my database

 

date_posted (date) 0000-00-00

 

what should be in my query if i wanted just to get the value of the day?

 

let say

 

			<?
		$uSql = "SELECT date_posted(i just wanted to get the day) FROM dates";
		$uResult = mysql_query($uSql, $connection);
		if(!$uResult){
		echo 'no data found';
		}else{
		while($uRow = mysql_fetch_array($uResult)){
			?>

 

whats the correct query for this?

thanks!

 

try this:

 

$query = "SELECT DATE_FORMAT(access.date_posted, '%d')As formatteddate1 
                               
        		 FROM access where icnumber='000000-00-1234' ";

Change ur table name where i put access.

Then acho it like this:

 

echo "<td>" . $row['formatteddate1'] . "</td></font>";

 

[pixeltrace]

thanks!

 

my form is working fine now.

[mmarif4u]

You Welcom