Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

mysql sql select one day before

SELECT * 
  FROM TABLE t
 WHERE t.date BETWEEN DATE_SUB('2010-07-29', INTERVAL 1 DAY)
                  AND '2010-07-29'
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #mysql #sql #select #day
ADD COMMENT
Topic
Name
1+5 =