Birthday format identification

Hi,

I have a table in database that contains birthday column varchar()- i choose varchar
because ecoder could input birthday like

1. 1993-14-03
2. 1993-03-14
3. March 14
4. March 14,1993
5.etc....

Now my problem i want to detect what month is their birthday could some help me?

Research strtotime(). It will allow you to convert the string to a unix timestamp. Then you can use the timestamp and date() to get the month.

Thanks a lot

You will run into problems allowing any date format like that. What date is "02-01-1990"? Feb 1 or Jan 2? strtotime won't help you decide either, it will just assume the format based on most likely the system locale format or just assume m-d-y. It won't automagically read the persons mind and know if it is jan or feb. Ideally you would control the format they enter. Use dropdowns to collect the month, day and year separately and then you know each value to put the date into the format you expect and better yet use an actual date field in mysql for storage. then you can sort, do maths and change the format to whatever the user wants to see.