MMartin1 (2/24/2015)
I for one like the yyyy-mm-dd notation. In other countries a '20140711' could be interpreted as Nov 07, 2014. If you changed the default language setting on your machine then that could do it. Just something to keep in mind if you keep track of events that happen globally (like user clicks) and they get shared globally.
For date strings, YYYYMMDD is ISO standard, and 20140711 should always be converted to July 11, 2014 regardless of localization settings or RDMS platform.
However, 2014-07-11 assumes YYYY-MM-DD only in the US and maybe few other places and is subject to interpretation.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho