Just wondering if any of you could provide me with any help to the following statement.
"SQL has a well defined standard that enables portability between different database environments”.
I understand SQL is used across all the major RDBMS but in different flavours, for want of a better word.
Ummm...and what "help" do you want?
Yes, in theory ANSI SQL is portable. In practice every DB indeed has its own "flavor", particularly when it comes to DATETIME data type (no two of the major DBs store DATETIME the same or use the same functions) and to functions in support of string manipulation.
MySQL is especially egregious in doing things in its own way. For example, its support for GROUP BY is not the same as that of any other DB that I know of.