Hi

I have added one block , there i am displaying the current months tickets by department wise. I added some links for the previous months like (April, May , June).When the user clicks on the month that months tickets should be displayed for that i have changed in index.php, but i am facing a probelm while retrieveing the records of that month.

QUERY:select xt.*,(UNIX_TIMESTAMP() - xt.posted) as elapsed,Qual1,priority,status from corp_xhelp_departments xd, corp_xhelp_tickets xt,corp_xhelp_ticket_values xtv where xd.id=xt.department and xt.id=xtv.ticketid and posted between
MARCH 1ST AND MARCH 31ST

suppose i want to get the records from March 1st to MArch 31st. How can i convert the MArch 1st and MArch 31st as unix timestamp.

can any one plz help me out.


Thanks & Regard

BSK