Would anyone know why I can only use the above format to show the dates? I'm getting dates with periods, but if I change the format to have blanks (where period is) or slash (/) I get nothing. I'm running MySQL on a local install for dev/testing purposes. I need to have the date formatted with slashes, like this 01/23/2014.
This is what my SQL is using right now:
DATE_FORMAT(DATE_ADD('1970-01-01', INTERVAL st.timemodified SECOND),'%c.%d.%Y')