Return to Snippet

Revision: 5112
at February 12, 2008 10:21 by Abe

Initial Code
# Original SQL
SELECT name, last_name, birthday FROM people

#Modified SQL
SELECT name, last_name, IF( birthday = '0000-00-00',  NULL, birthday) AS birthday FROM people

Initial URL

Initial Description
An easy way to handle null dates. If date = 0000-00-00 then null, else use date

Initial Title
Date 0000-00-00

Initial Tags
sql, date

Initial Language