<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<style type="text/css" media="all">
a:hover { color: red; }
a {
text-decoration: none;
color: #0088cc;
}
a.primaryactionlink:link, a.primaryactionlink:visited { background-color: #2585B2; color: #fff; }
a.primaryactionlink:hover, a.primaryactionlink:active { background-color: #11729E !important; color: #fff !important; }
/*
@media only screen and (max-device-width: 480px) {
.post { min-width: 700px !important; }
}
*/
</style>
<title>WordPress.com</title>
<!--[if gte mso 12]>
<style type="text/css" media="all">
body {
font-family: arial;
font-size: 0.8em;
}
.post, .comment {
background-color: white !important;
line-height: 1.4em !important;
}
</style>
<![endif]-->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body style="background: #DDDDDD; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; color: #666; text-align: center; margin: 0; padding: 0;" class="subscription-body-tag">Salve.<br>Aggiunto il supporto alle funzioni data e ora in qgis.<br>Buon divertimento.<br><br>---<br><a href="http://faunalia.it/pc">http://faunalia.it/pc</a><br>Sent from mobile, sorry for being short<br><br><div id="htc_header" style="">----- Forwarded message -----<br>Da: "Nathans QGIS and GIS blog" <donotreply@wordpress.com><br>A: <cavallini@faunalia.it><br>Oggetto: [New post] Better date and time support in QGIS expressions and styles<br>Data: sab, giu 30, 2012 14:46<br><br></div><br>
<table border="0" cellspacing="0" cellpadding="0" bgcolor="#DDDDDD" style="background: #DDDDDD; width: 100%;">
<tr>
<td>
<table border="0" cellspacing="0" cellpadding="0" align='center' style="padding: 10px; width: 100%;" class="subscribe-body">
<tr>
<td>
<div style="max-width: 600px; margin: 0 auto; overflow: hidden;">
<table border="0" cellspacing="0" cellpadding="0" bgcolor="#ffffff" style="background-color: #fff; text-align: left; margin: 0 auto; max-width: 1024px; min-width: 320px; width: 100%;" class="subscribe-wrapper">
<tr>
<td>
<table border="0" cellspacing="0" cellpadding="0" height="8" background="http:/s.wordpress.com/i/emails/stripes.gif" style="background-image: url( 'http:/s.wordpress.com/i/emails/stripes.gif'); background-repeat: repeat-x; background-color: #43A4D0; height: 8px; width: 100%;" class="subscribe-header-wrap">
<tr>
<td></td>
</tr>
</table>
<table border="0" cellspacing="0" cellpadding="0" style="color: #0088cc; margin: 0 0 5px 0; font-size: 1.6em; color: #0088cc; margin: 0 0 0px 0; font-size: 1.6em; background-color: #EFEFEF; padding: 0; border-bottom: 1px solid #DDD; width: 100%;" class="subscribe-header">
<tr>
<td>
<h2 style="padding: 0px; margin: 5px 20px; font-size: 16px; line-height: 1; font-weight: normal; color: #464646; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;" class="subscribe-title">
New post on <strong>Nathans QGIS and GIS blog</strong> </h2>
</td>
<td style="text-align: right;">
<img border="0" style="margin: 5px 20px 5px 0; vertical-align: middle;" class="head-avatar" src='http://s.wordpress.com/i/emails/blavatar-default.png' alt='' style='vertical-align: middle;' />
</td>
</tr>
</table>
<table border="0" cellspacing="0" cellpadding="20" bgcolor="#ffffff" style="width: 100%;">
<tr>
<td>
<table border="0" cellspacing="0" cellpadding="0" style="width: 100%;">
<tr>
<td valign="top" class="the-post">
<table border="0" cellspacing="0" cellpadding="0" style="width: 100%;">
<tr>
<td style="width: 60px !important; white-space: nowrap; vertical-align: top;">
<a href="http://woostuff.wordpress.com/author/madmanwoo/" style="display: block; margin-right: 10px; text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;"><img border="0" alt='' src='http://0.gravatar.com/avatar/03ccba009c26488991d9ec669e3fccf6?s=50&d=' class='avatar avatar-50' height='50' width='50' /></a>
</td>
<td>
<h2 style="margin: 0; font-size: 1.6em; color: #555; margin: 0; font-size: 1.6em; color: #555; font-size: 20px;" class="post-title"><a style="text-decoration: none !important; text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;" href="http://woostuff.wordpress.com/2012/06/30/better-date-and-time-support-in-qgis-expressions-and-styles/">Better date and time support in QGIS expressions and styles</a></h2>
<span style="color: #888;">by <a href="http://woostuff.wordpress.com/author/madmanwoo/" style="color: #888 !important; text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;">Nathan</a></span>
</td>
</tr>
</table>
<div style="margin-top: 1em; max-width: 560px;" class="post-content">
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;"><strong>Version note: This will only work in the latest dev build of QGIS - not in 1.8</strong></p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">The lack of uni for the next couple of weeks has left me some time at night to work on some features that I really wish QGIS had. One of these features was better date and time support in the expression engine. Date and time is an important concept when working on inspection data and not being able to style my features in QGIS using date operations was bugging me. So in good open source fashion I added some.</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">Here are the current functions (more to come in the future):</p>
<ul style="margin: 0; padding: 0; margin-left: 1em; margin: 0; padding: 0; margin-left: 1em; font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;">
<li style="line-height: 1.6; margin-left: 1em; line-height: 1.6; margin-left: 1em; font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;">$now - <em>returns the current date and time</em></li>
<li style="line-height: 1.6; margin-left: 1em; line-height: 1.6; margin-left: 1em; font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><em>age({datetime},{datetime}) - </em>returns the difference between the two dates</li>
<li style="line-height: 1.6; margin-left: 1em; line-height: 1.6; margin-left: 1em; font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;">todate({string}) - <em>converts a string to date type</em></li>
<li style="line-height: 1.6; margin-left: 1em; line-height: 1.6; margin-left: 1em; font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><em>totime({string}) - converts a string to time type</em></li>
<li style="line-height: 1.6; margin-left: 1em; line-height: 1.6; margin-left: 1em; font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><em>tointerval({string}) - converts a string to a interval type (details below)</em></li>
<li style="line-height: 1.6; margin-left: 1em; line-height: 1.6; margin-left: 1em; font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><em>day({datetime} or {interval}) - returns the day from a datetime type or the number of days in a interval.</em></li>
<li style="line-height: 1.6; margin-left: 1em; line-height: 1.6; margin-left: 1em; font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><em>hour(...) - Same as above but for hours</em></li>
<li style="line-height: 1.6; margin-left: 1em; line-height: 1.6; margin-left: 1em; font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><em>minute(...) <em> - Same as above but for minutes</em></em></li>
<li style="line-height: 1.6; margin-left: 1em; line-height: 1.6; margin-left: 1em; font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><em>second(...) <em> - Same as above but for seconds</em></em></li>
<li style="line-height: 1.6; margin-left: 1em; line-height: 1.6; margin-left: 1em; font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><em>day(..) <em> - Same as above but for days</em></em></li>
<li style="line-height: 1.6; margin-left: 1em; line-height: 1.6; margin-left: 1em; font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><em>week(..) <em> - Same as above but for weeks</em></em></li>
<li style="line-height: 1.6; margin-left: 1em; line-height: 1.6; margin-left: 1em; font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><em>month(...) <em> - Same as above but for months</em></em></li>
<li style="line-height: 1.6; margin-left: 1em; line-height: 1.6; margin-left: 1em; font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><em>year(...)<em> - Same as above but for years</em></em></li>
<li style="line-height: 1.6; margin-left: 1em; line-height: 1.6; margin-left: 1em; font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><em>{datetime} - {interval} = {new datetime} - returns a new datetime subtracting the interval </em></li>
<li style="line-height: 1.6; margin-left: 1em; line-height: 1.6; margin-left: 1em; font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><em><em>{datetime} + {interval} = {new datetime} - returns a new datetime adding the interval</em></em></li>
</ul>
<h2><em><strong><br />
</strong></em>The interval type</h2>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">Functions like <em>age(..),</em> <em>toiterval(), {datetime} -/+ {interval}, day(..), hour(..), etc, </em>use, or return, Intervals. An Interval is a measure of time that we can use for different things. An example of an Interval is '1 Year 2 Months' this is then converted to a number of seconds and used for any calculations.</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">For example one can take away 10 days from the current date by doing the following ( -> marks the output ):</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
<pre class="brush: sql;" style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
todate($now - '10 Days')
-> 2012-06-20
</pre>
</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">as</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
<pre class="brush: sql;" style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
todate($now)
-> 2012-06-30
</pre>
</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">We can also do something like:</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
<pre class="brush: sql;" style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
todate($now + '2 Years 1 Month 10 Days')
-> 2014-08-10
</pre>
</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">The age() function will return an interval which we can use extract what information we need.</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">The number of days between two dates:</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
<pre class="brush: sql;" style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
day(age('2012-06-30', '2012-06-10'))
-> 20
-- Think of it as '2012-06-30' - '2012-06-10'
-- Note: day(), month(), etc, functions return doubles so you can get
-- 21.135234 days if you are using date & time type rather than just date type
-- wrap the result in toint() to get a more sane output.
</pre>
</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">Day() will also work on a plain date:</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
<pre class="brush: sql;" style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
day('2012-06-30')
-> 30
</pre>
</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">We can even get the number of seconds between two dates:</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
<pre class="brush: sql;" style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
second(age('2012-06-30', '2012-06-10'))
-> 1728000
</pre>
</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">Currently the only date format supported is {year}-{month}-{day} as seen in the examples above. Shouldn't be too hard to add support to the todate(), todatetime(), totime() functions for giving it a pattern to use when converting the string e.g. dd-mm-YYYY, or something like that.</p>
<h2>More on this fancy new stuff</h2>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">When I wrote the new<a title="Expression based labeling now in QGIS." href="http://woostuff.wordpress.com/2011/10/27/expression-based-labeling/" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;"> expression builder</a> dialog a while ago I made it dynamic so that any new functions added to the expression engine will show up automatically. So here they are:</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
<div id="attachment_1056" class="" style=" clear:both; text-align: center; margin: 0 auto; padding: 4px; background-color: white; border: 1px solid #ccc"><a href="http://woostuff.files.wordpress.com/2012/06/functions.png" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;"><img border="0" style="max-width: 100%; height: auto; margin-bottom: 12px;" class="size-full wp-image-1056" title="functions" src="http://woostuff.files.wordpress.com/2012/06/functions.png" alt="" /></a>
<p class="wp-caption-text" style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">List of new date and time functions.</p>
</div>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">We can also use these functions in the rule based rending, which is where the power really comes in. Lets see something like that in action:</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
<div id="attachment_1058" class="" style=" clear:both; text-align: center; margin: 0 auto; padding: 4px; background-color: white; border: 1px solid #ccc"><a href="http://woostuff.files.wordpress.com/2012/06/dates-style1.png" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;"><img border="0" style="max-width: 100%; height: auto; margin-bottom: 12px;" class="size-full wp-image-1058" title="dates style" src="http://woostuff.files.wordpress.com/2012/06/dates-style1.png" alt="" /></a>
<p class="wp-caption-text" style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">Styled using days and years</p>
</div>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">Should be pretty straight forward to understand. We are using the age() and day() functions to style the events that are older than 30 days, within 30 days, for today, or in the future. We also check the year of the event using year() and year($now) to make sure we only see this years events, or style them differently depending on if they are last years events or in the future.</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">This is the result of the above rules:</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
<div id="attachment_1059" class="" style=" clear:both; text-align: center; margin: 0 auto; padding: 4px; background-color: white; border: 1px solid #ccc"><a href="http://woostuff.files.wordpress.com/2012/06/style-result.png" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;"><img border="0" style="max-width: 100%; height: auto; margin-bottom: 12px;" class="size-full wp-image-1059" title="style result" src="http://woostuff.files.wordpress.com/2012/06/style-result.png" alt="" /></a>
<p class="wp-caption-text" style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">Result of using date functions in rule based renderer</p>
</div>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">I'm also using the date functions in the expression based labelling to label the features using the following expression:</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
<pre class="brush: sql;" style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
CASE
WHEN year( "dateadded") < year($now) THEN
'Last Year'
WHEN day(age("dateadded", $now)) < 0 THEN
day(age("dateadded", todate($now))) || ' Days old'
ELSE
day(age("dateadded", todate($now))) || ' Days to go'
END
</pre>
</p>
<p style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">Well that's it. Hope you find it handy in your day-to-day mapping. I know I will be using it a lot.<br />
Thanks to Martin and Jürgen for the code reviews during the process; venturing in an unknown part of the code base always makes me nervous but that is all part of learning, and sometimes you can make some pretty cool stuff.<br />
<em><strong>Some other random notes: </strong>The general idea has been modelled of how Postgres handles dates and times, it's not an exact copy but follows the same kind of ideas. The interval class also uses the same number of seconds for one year that postgres does so that we can be consistent with the output.</em></p>
<div style="clear: both"></div> </div>
<div style="color: #999; font-size: 0.9em; margin-top: 4px; color: #999; font-size: 0.9em; margin-top: 4px; line-height: 160%; padding: 15px 0 15px; border-top: 1px solid #eee; border-bottom: 1px solid #eee; overflow: hidden" class="meta">
<strong><a href="http://woostuff.wordpress.com/author/madmanwoo/" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;">Nathan</a></strong> | June 30, 2012 at 10:46 pm | Tags: <a href="http://woostuff.wordpress.com/?tag=fossgis" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;">FOSSGIS</a>, <a href="http://woostuff.wordpress.com/?tag=gis" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;">gis</a>, <a href="http://woostuff.wordpress.com/?tag=map-rendering" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;">map-rendering</a>, <a href="http://woostuff.wordpress.com/?tag=open-source" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;">Open Source</a>, <a href="http://woostuff.wordpress.com/?tag=osgeo" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;">osgeo</a>, <a href="http://woostuff.wordpress.com/?tag=qgis" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;">qgis</a>, <a href="http://woostuff.wordpress.com/?tag=quantum-gis" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;">Quantum GIS</a>, <a href="http://woostuff.wordpress.com/?tag=styling" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;">styling</a>
| Categories: <a href="http://woostuff.wordpress.com/?cat=25" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;">Open Source</a>, <a href="http://woostuff.wordpress.com/?cat=534019" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;">qgis</a>
| URL: <a href="http://wp.me/pjIwZ-gP" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;">http://wp.me/pjIwZ-gP</a> </div>
<p style="font-size: 14px; padding: 0; color: #666; padding-top: 1em; padding-bottom: 0em; margin-bottom: 0; margin-left: 0; padding-left: 0;" class="subscribe-action-links">
<table border="0" cellspacing="0" cellpadding="0" style="width: 100%;">
<tr>
<td style="width: 10px;"><a style='-moz-border-radius: 10em; -webkit-border-radius: 10em; border-radius: 10em; border: 1px solid #11729E; text-decoration: none; color: #fff; text-shadow: 0 1px 0 #11729E; background-color: #2585B2; padding: 5px 15px; font-size: 16px; line-height: 1.4em; font-family: Helvetica Neue, Helvetica, Arial, sans-serif; font-weight: normal; margin-left: 0; white-space: nowrap;' href="http://woostuff.wordpress.com/2012/06/30/better-date-and-time-support-in-qgis-expressions-and-styles/#respond" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;">Comment</a></td>
<td> <a style="font-size: 14px; text-decoration: underline; text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;" class="subscribe-action-link" href="http://woostuff.wordpress.com/2012/06/30/better-date-and-time-support-in-qgis-expressions-and-styles/#comments">See all comments</a></td>
</tr>
</table>
</p>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table border="0" cellspacing="0" cellpadding="20" bgcolor="#efefef" style="background-color: #efefef; text-align: left; border-top: 1px solid #dddddd; width: 100%;" class="subscribe-wrapper-sub">
<tr>
<td style="border-top: 1px solid #f3f3f3; color: #888; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; background: #efefef;" class="subscribe-content">
<p style='font-size: 12px; line-height: 1.4em; margin: 0px 0px 10px 0px;' style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
Unsubscribe or change your email settings at <a href="https://subscribe.wordpress.com/?key=5d8fffc771bced9f7eeeda3b07f875c6&email=cavallini%40faunalia.it" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;">Manage Subscriptions</a>. </p>
<p style='font-size: 12px; line-height: 1.4em; margin: 0px 0px 0px 0px;' style="font-size: 14px; line-height: 1.4em; color: #444444; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; margin: 0 0 1em 0;">
<strong>Trouble clicking?</strong> Copy and paste this URL into your browser: <br />
<a href="http://woostuff.wordpress.com/2012/06/30/better-date-and-time-support-in-qgis-expressions-and-styles/" style="text-decoration: none; color: #0088cc; text-decoration: underline; color: #2585B2;">http://woostuff.wordpress.com/2012/06/30/better-date-and-time-support-in-qgis-expressions-and-styles/</a>
</p>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table border="0" cellspacing="0" cellpadding="0" height="3" background="http:/s.wordpress.com/i/emails/stripes.gif" style="background-image: url( 'http://s.wordpress.com/i/emails/stripes.gif'); background-repeat: repeat-x; background-color: #43A4D0; height: 3px; width: 100%;" class="subscribe-footer-wrap">
<tr>
<td></td>
</tr>
</table>
</div>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align='center' style="padding-bottom: 2em; color: #555555; font-size: 12px; height: 18px; text-align: center; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; width: 100%;" class="subscribe-footer">
<tr>
<td align='center'>
<a style="font-size: 14px; color: #555555 !important; text-decoration: none; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; color: #555 !important; font-size: 14px; text-decoration: none;" class="subscribe-footer-link" href="http://wordpress.com">Thanks for flying with <img border="0" src="http://s.wordpress.com/i/emails/wp-footericon.png" alt="" style="vertical-align: middle;" width="16" and height="17" /> WordPress.com</a> </td>
</tr>
</table>
<br />
</td>
</tr>
</table>
<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=woostuff.wordpress.com&blog=4699413&post=1043&subd=woostuff&ref=&email=1&email_o=wpcom" width="1" height="1" /></body></html>