Coding using SQL date_format
Posted: Fri Jun 27, 2008 10:22 pm
I have seen discussion in here about using the SQL date format for date output formatting. People say that it is best to have SQL do the date processing rather than PHP. I have talked to others that say that there are anomalies in the date_format parameters between different flavors of SQL (PostgreSql, MS-SQL, MySQL, etc...). If this is the case and you are trying to code a universal application using the PEAR DB or MDB2 abstraction layers that could be used on any of the supported databases, wouldn't this cause compatibility issues? Wouldn't the PHP date function be better in that case?