[SOLVED] MYSQL DAte Question

[djbuddhi]

Guys;

              How 2 get the last date of the current month in mysql

 

Exp

 

if the system month is February return should be 29

 

like that ,how to get it ?

 

need help... :o

[cooldude832]

are u using it with php at all?  because php can do it a lot easier

[djbuddhi]

yes php 4.3.3

[akitchin]

i see no reason why MySQL can't be used for this:

 

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_last-day

 

that does exactly what you need, and most likely in an easier fashion than php.

[djbuddhi]

thanks pal

[cooldude832]

well now that is a handy tip I was gonna say use mktime in php and then just make it this month +1 and the day be -1 to get what u wanted.

 

 

What a directly obvious mysql answer

[djbuddhi]

hey cooldude832

 

can u post the code ,i am not familiar with the mKtime this thing :

[cooldude832]

<?php
$last_day = date("Y-m-d",mktime(0,0,0,date("m")+1,-1,date("Y"));
?>

 

http://us.php.net/mktime

 

should return

2008-08-31 if ran in august

[djbuddhi]

thanks 4 the support buddy  ;D

 

have a good day

TC

[djbuddhi]

i have a good method and it works

 

<?php

$num = cal_days_in_month(CAL_GREGORIAN, 2, 2008) ;

echo "There were $num days in May 2008";

?>