Search records for a given day of the week

Asked

Viewed 82 times

1

Staff I have the following select

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

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

Thank you :D

mysql sql select

1 answer

2

Guys got doing some tests here with the following query

WHERE WEEKDAY(DATA) = 1

:D

  • this way displays results registered on Sunday (1 Sunday, 2 Monday....)

Browser other questions tagged mysql sql select

You are not signed in. Login or sign up in order to post.