http://snipplr.com/language/sql/tags/null Recent snippets posted on Snipplr.com en-us Sun, 19 May 2013 08:43:54 GMT http://snipplr.com/view/58803/if-mysqlquery-is-not-empty/

]]> Mon, 19 Sep 2011 22:49:26 GMT http://snipplr.com/view/58803/if-mysqlquery-is-not-empty/ http://snipplr.com/view/15198/sap-date-comparison/ this little snippet can be used to compare an SAP Date (which might be empty, or '00000000') to today's date, for instance to query for rows that have been closed in the last x days. Can't CAST the date column (in 'YYYYMMDD' format) to a date for use in where clauses, since '00000000' can't be cast to a datetime

]]> Wed, 20 May 2009 13:14:30 GMT http://snipplr.com/view/15198/sap-date-comparison/ http://snipplr.com/view/5019/date-00000000/ An easy way to handle null dates. If date = 0000-00-00 then null, else use date

]]> Tue, 12 Feb 2008 10:21:20 GMT http://snipplr.com/view/5019/date-00000000/