Re: Timestamp query...

>The field is join_date_time and the values are something like: >20040222000015 >20040223015329 > >Everything is working fine and dandy except now that the client wants a >search functionality in his "control panel" where he can enter the day, >month, year and see all the people who have joined on that particular >date... > >I have created 3 text boxes in the html form named mm,dd,yyyy....but how >do i search on that? All you need is substr() and the mysql keyword 'like', and you should be all set. Why didn't you make join_date_time a datetime in the first place? --------------------------------------------------------------------- michal migurski- contact info and pgp key: sf/ca http://mike.teczno.com/contact.html