mirror of
https://github.com/qgis/QGIS.git
synced 2025-02-22 00:06:12 -05:00
22 lines
791 B
Plaintext
22 lines
791 B
Plaintext
{
|
|
"name": "to_interval",
|
|
"type": "function",
|
|
"groups": ["Conversions", "Date and Time"],
|
|
"description": "Converts a string to an interval type. Can be used to take days, hours, month, etc of a date.",
|
|
"arguments": [{
|
|
"arg": "string",
|
|
"description": "a string representing an interval. Allowable formats include {n} days {n} hours {n} months."
|
|
}],
|
|
"examples": [{
|
|
"expression": "to_interval('1 day 2 hours')",
|
|
"returns": "interval: 1.08333 days"
|
|
}, {
|
|
"expression": "to_interval( '0.5 hours' )",
|
|
"returns": "interval: 30 minutes"
|
|
}, {
|
|
"expression": "to_datetime('2012-05-05 12:00:00') - to_interval('1 day 2 hours')",
|
|
"returns": "2012-05-04T10:00:00"
|
|
}],
|
|
"tags": ["type", "month", "converts", "date", "interval", "take", "hours", "days"]
|
|
}
|