Changeset 932 for trunk/core/data/System/QuerySearch.txt
- Timestamp:
- 11/25/08 01:44:50 (4 years ago)
- File:
-
- 1 edited
-
trunk/core/data/System/QuerySearch.txt (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
trunk/core/data/System/QuerySearch.txt
r851 r932 102 102 | =lc(x)= | Converts x to lower case, Use for caseless comparisons. | 103 103 | =uc(x)= | Converts x to UPPER CASE. Use for caseless comparisons. | 104 | =d2n(x)= | Converts a date (expressed in [[TimeSpecifications][one of the formats that Foswiki can parse]]) to a number of seconds since 1st Jan 1970. This is the format dates are stored in inside Foswiki, and you have to convert a string date using =d2n= before you can compare it with - for example - the date an attachment was uploaded. Times without a timezone are assumed to be in server local time. If you have date fields in your forms, note that they are *not* stored in TWiki's internal format, but are stored as text strings. You should still use =d2n= to convert them to numbers for comparisons, though. |104 | =d2n(x)= | Converts a date (expressed in [[TimeSpecifications][one of the formats that Foswiki can parse]]) to a number of seconds since 1st Jan 1970. This is the format dates are stored in inside Foswiki, and you have to convert a string date using =d2n= before you can compare it with - for example - the date an attachment was uploaded. Times without a timezone are assumed to be in server local time. If you have date fields in your forms, note that they are *not* stored in Foswiki's internal format, but are stored as text strings. You should still use =d2n= to convert them to numbers for comparisons, though. | 105 105 | =NOT= | Invert the result of the subquery | 106 106 | =AND= | Combine two subqueries |
Note: See TracChangeset
for help on using the changeset viewer.
