Date and time functions
You can use these date-manipulation and time-manipulation functions to place files based on when the files are created and the local time of the GPFS node serving the directory where the file is being created.
- CURRENT_DATE
- Determines the current date on the GPFS server.
- CURRENT_TIMESTAMP
- Determines the current date and time on the GPFS server.
- DAYOFWEEK(x)
- Determines the day of the week from date or timestamp x. The day of a week is from 1 to 7 (Sunday is 1).
- DAYOFYEAR(x)
- Determines the day of the year from date x. The day of a year is a number from 1 to 366.
- DAY(x)
- Determines the day of the month from date or timestamp x.
- DAYS(x)
- Determines the number of days between date or timestamp x and 0001-01-01.
- DAYSINMONTH(x)
- Determines the number of days in the month of date x.
- DAYSINYEAR(x)
- Determines the day of the year of date x.
- HOUR(x)
- Determines the hour of the day (a value from 0 to 23) of timestamp x.
- MINUTE(x)
- Determines the minute from timestamp x.
- MONTH(x)
- Determines the month of the year from date or timestamp x.
- QUARTER(x)
- Determines the quarter of year from date x. Quarter values are the numbers 1 through 4. For example, January, February, and March are in quarter 1.
- SECOND(x)
- Returns the seconds portion of timestamp x.
- TIMESTAMP(sql-numeric-value) or TIMESTAMP(sql-character-string-value)
- Accepts
any numeric value. The numeric value is interpreted as the number
of seconds since January 1, 1970 (the standard UNIX epoch) and is converted to an SQL TIMESTAMP
value.
Signed 64-bit LARGEINT argument values are supported. Negative argument values cause TIMESTAMP to convert these values to timestamps that represent years before the UNIX epoch.
This function also accepts character strings of the form YYYY-MM-DD HH:MM:SS. A hyphen (-) or an at sign (@) might appear instead of the blank between the date and the time. The time can be omitted. An omitted time defaults to 00:00:00. The :SS field can be omitted, which defaults to 00.
- WEEK(x)
- Determines the week of the year from date x.
- YEAR(x)
- Determines the year from date or timestamp x.
All date and time functions use Universal Time (UT).
Example of a policy rules file
/*
Sample GPFS policy rules file
*/
rule 'vip' set pool 'pool0' where USER_ID <= 100
RULE 'm1' SET POOL 'pool1' WHERE LOWER(NAME) LIKE '%marc%'
RULE SET POOL 'pool1' REPLICATE (2) WHERE UPPER(NAME) = '%IBM%'
RULE 'r2' SET POOL 'pool2' WHERE UPPER(SUBSTRING(NAME FROM 1 FOR 4)) = 'GPFS'
RULE 'r3' SET POOL 'pool3' WHERE LOWER(SUBSTR(NAME,1,5)) = 'roger'
RULE SET POOL 'pool4' WHERE LENGTH(NAME) = 7
RULE SET POOL 'pool5' WHERE name like 'xyz%' AND name like '%qed' OR name like '%.tmp%'
RULE SET POOL 'pool6' WHERE name like 'abc%' OR name like '%xyz' AND name like 'x%'
RULE 'restore' RESTORE TO POOL 'pool0' where USER_ID <= 100
/* If none of the rules matches put those files in system pool */
rule 'default' SET POOL 'system'