• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 411
  • Last Modified:

month and year picker

hi , i need a month and year picker  not a normal date picker , ve to use in jsp to pick only month and year
thanks in adv
0
inickinfosystems
Asked:
inickinfosystems
1 Solution
 
k_murli_krishnaCommented:
MONTH(date)
Returns the month for date, in the range 1 to 12 for January to December, or 0 for dates such as '0000-00-00' or '2008-00-00' that have a zero month part.
mysql> SELECT MONTH('2008-02-03');
        -> 2

YEAR(date)
Returns the year for date, in the range 1000 to 9999, or 0 for the zero date.
mysql> SELECT YEAR('1987-01-01');
        -> 1987
0
 
arevuriCommented:
Display two combo boxes in your picker div or small popup window. and assign the selected combo box values to your parent window using opener object (like opener.document.forms[0].yourtxfiled=document.forms[0].monthCombobox.selected)
 
 
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now