Date expressions reference guide
Fisheye supports a wide variety of date expressions. A date has the two possible general forms:
DATE[+-]TIMEZONE[+-]DURATION, orDATECONSTANT[+-]DURATION.
The TIMEZONE and DURATION parts are both optional.
TIMEZONE can be an offset from GMT HHMM or HH:MM, or simply the letter Z to denote GMT. If no timezone is given, the Fisheye server's configured timezone is used.
DATE can be either of the following:
| Specifies a time and date (separated by a |
| Specifies 00:00:00 on the given date. A / can be used instead of - as a separator. |
DATECONSTANT can be any of:
| This very instant (at the time the expression was evaluated). |
| The instant at 00:00:00 today. (server-time* or GMT) |
| The instant at 00:00:00 on the first day of this week. Sunday is considered the first day. (server-time* or GMT) |
| The instant at 00:00:00 on the first day of this month. (server-time* or GMT) |
| The instant at 00:00:00 on the first day of this year. (server-time* or GMT) |
* The timezone used for server-time is part of the Fisheye configuration
The syntax for DURATION is similar to the XML Schema duration type. It has the general form PnYnMnDTnHnMnS. See Section 3.2.6 of the XML Schema Datatypes document for more details.
Examples
| The start of the day on January 1, 2005 (server's timezone) |
| The start of the day on January 1, 2005 at GMT offset -0500 (New York) |
| Midday, January 1, 2005 GMT |
| Yesterday (start of day) |
| Start of tomorrow |
| Start of last month |
| Start of next year |
| One hour ago |
| One hour, two minutes and three seconds from now |