Search for records on a certain day of the week

1

Personal I have the following select

set temp = Conn.Execute("SELECT * FROM tbl_estacionamento ORDER by id asc")

I have a table named date where I record the day of the information record, I would like to know how I can only display results recorded on Sundays.

Thanks: D

    
asked by anonymous 25.03.2017 / 11:46

1 answer

2

I've been able to do some tests here with the following query

WHERE WEEKDAY(DATA) = 1

: D

    
25.03.2017 / 11:58