Skip to content

Instantly share code, notes, and snippets.

@ferventcoder

ferventcoder/gist:1232364

Created September 21, 2011 15:26
Show Gist options
  • Save ferventcoder/1232364 to your computer and use it in GitHub Desktop.
Save ferventcoder/1232364 to your computer and use it in GitHub Desktop.
Download ZIP
Bugs 101 - Hiding content if the publish date has a time in it
Raw
gistfile1.sql
/*
Consider this, both dates below are in the past. One of these will show up, the other one will not.
*/
INSERT INTO articles (PublishedDate) VALUES ('2011-09-20 07:15:25')
--this one will show up
INSERT INTO articles (PublishedDate) VALUES ('2011-09-20 00:00:00')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment