WHERE date ?????

[donboe]

I need a query for populating a activity/participant list for printing. The list is feeded by two url variables:

activity_id and activity_date

The format (through my serverside scripting) for the activity_date in the drop down is:

dd mmm, yyyy

I only have know idea how to translate the Url.dateformat in to the right format in the where clause in my query. This is what I have so far:

 
  SELECT
          AL.activity_id
        , AL.activity_name_home_language
        , AD.activity_date
        , AP.bookings_number
        , P.persons
        , COUNT(persons) AS total_persons
        , P.first_name
        , P.last_name
        , P.telephone
  FROM
          activity_list AL
  INNER
    JOIN  activity_dates AD
      ON  AL.activity_id = AD.activity_id
  INNER
    JOIN  activity_participants AP
      ON  AL.activity_id = AP.activity_id    
  INNER
    JOIN  participants P
      ON  AP.participant_id = AD.participant_id 
  WHERE
          AL.activity_id = 'Url.activity_id'
  AND
          AD.activity_date = ?????

What would be the right format?

[r937]

since this is mysql, you should use the STR_TO_DATE function