MIME-Based Transformations - Mastering phpMyAdmin 2.11 for Effective MySQL Management - page 239

This transformation accepts two options. The first is the number of hours that will
be added to the original value (by default, this is zero.) Adding the number of hours
can be useful if we store all the times based on Universal Coordinated Time ( UTC ),
but want to display them for a specific zone (UTC+5). The second option is the time
format we want to use, made from any PHP strftime parameters. So, if we put this
in the transformation options, '0','Year: %Y' , we will get:
Links from Text
Suppose that we have put a complete URL: http://domain.com/abc.pdf —in
the description field in our book table. The text of the link will be displayed while
browsing the table, but we would not be able to click it. We'll now see the use of the
text/plain MIME type in such a situation.
text/plain: link
If we use a MIME type of text/plain and a browser transformation of text/plain: link ,
in the scenario just mentioned, we will still see the text for the link, and it will
be clickable:
If all the documents that we want to point to, are located at a common URL prefix,
we can put this prefix (for example, http://domain.com/ ) in the first transformation
option, with the enclosing quotes. Then, we would only put the last part of the URL
( abc.pdf ) in each cell.