January 7th, 2013, 10:45 AM
Should database be used for date formatting
Most will say that the database should not be used to format data, and instead format presentation should be left to the view/application.
Does this concept also apply to formatting dates?
January 7th, 2013, 10:50 AM
It applies especially to dates. The end user should be able to view dates in the way that makes most sense to them. For me that's 'd-m-y'. For Americans it's 'm-d-y'.
January 7th, 2013, 11:04 AM
Thanks caelatte. Thought so, but I've been queries like DATE_FORMAT(myDateColumn,"%m/%d/%Y") for so long, I didn't trust my judgement.
Originally Posted by cafelatte