[AccessD] weekdays

Hello Group,

i now that there is an sql that can give me the days of the week fo a specific date, but i can't find it right now.

Who can help me?

i have:
date
16-02-06
17-02-06

i need:
date             day
16-02-06        thursday
17-02-06        friday

Pedro Janssen