[RESOLVED] Date Query

[sakamali]

Hi everyone.
I have 2 pages. I listed in checkbox some values that from 1 to 12 on first.php. Then, i want to print to screen which the chosen months values by these codes :

$parametre=$_POST["month_list"];
$p = mssql_query("SELECT * FROM tbl_Bildirimler WHERE bildirim_tarihi >= '".$parametre.".01.2009' AND bildirim_tarihi < '".$parametre.".31.2009'",$con); 

I saw this error message :

Warning:  mssql_query() [function.mssql-query]: message: Conversion failed when converting datetime from character string. (severity 16) in /opt/lampp/htdocs/hd/iki.php on line 39 

I use MSSQL Server and my database's field (bildirim_tarihi) type is datetype. I just want to see chosen month's values from database. For example:
I choose "12" in first.php and press Submit button. This value goes second.php called "month_list". So, i want to see values belongs to between 12.01.2009 and 12.31.2009.

I apologize for my English and waiting for your help.
Regards..

[johanafm]

Well, unless MSSQL allows non standard SQL dates, you need to use dates on the format YYYY-MM-DD

[sakamali]

johanafm;10927572 wrote:

Well, unless MSSQL allows non standard SQL dates, you need to use dates on the format YYYY-MM-DD

I'm sorry. I wrong. My database's field (bildirim_tarihi) type is datetime.

[sakamali]

... and i have still taking same error message 🙁

[sakamali]

I solved the problem and codes are in here. Thank you for your helps.

 $p = mssql_query("SELECT * FROM tbl_Bildirimler WHERE MONTH(bildirim_tarihi) = '$parametre'",$con);