Time operators in Oxla allow you to perform various operations on dates, times, and intervals. Here’s a guide to using these operators:
1. DATE + INTEGER
Add a specific number of days to a date.Example
select date '2022-03-15' + 14 as "result";
The result will be 14 days after ‘2022-03-15’.
result ------------ 2022-03-29
1.1. INTEGER + DATE
Adding and multiplying time operators can also be done in reverse order. For example, we add a number of days to a date in the format of Integer + Date.
select 14 + date '2022-03-15' AS "result";
The result will be the same, which is 14 days after ‘2022-03-15’ is ‘2022-03-29’.
result ------------ 2022-03-29
2. DATE + INTERVAL
Add a specified interval to a date.Example
select date '2022-03-15' + interval '3 months' as "result";
The result will be the date three months after ‘2022-03-15’.
result ---------------------------- 2022-06-15 00:00:00.000000
3. DATE - INTEGER
Subtract a certain number of days from a date.Example
select date '2022-03-15' - 7 as "result";
The result will be 7 days before ‘2022-03-15’.
result ------------ 2022-03-08
4. DATE - INTERVAL
Subtract a specified interval from a date.Example
select date '2022-03-15' - interval '2 hour' as "result";
The result will be the timestamp with two hours before ‘2022-03-15’.
result ---------------------------- 2022-03-14 22:00:00.000000
5. DATE - DATE
Subtract dates.Example
select date '2023-03-15' - date '2023-01-10' as "result";
The number of days elapsed between ‘2023-03-15’ and ‘2023-01-10’ is 64 days.
result -------- 64
6. DATE + TIME
Add a time-of-day to a date.Example
select date '2010-05-20' + time '02:00' as "result";
The result will be a timestamp with the specified time added to the given date.
result ---------------------------- 2010-05-20 02:00:00.000000
7. TIME + INTERVAL
Add a certain interval to a given time.Example
select time '12:30' + interval '1 hour' as "result";
The result will be the time 1 hour after ‘12:30’.
result ----------------- 13:30:00.000000
8. TIME - INTERVAL
Subtract a specified interval from a given time.Example
select time '18:45' - interval '45 minutes' as "result";
The result will be the time 18:00.
result ----------------- 18:00:00.000000
9. TIME - TIME
Get a time difference by subtracting one time from another.Example
select time '10:00' - TIME '08:20' as "result";
In this example, the time difference between the two provided times is 1 hour and 40 minutes.
result ----------------- 01:40:00.000000
10. TIMESTAMP + INTERVAL
Add a timestamp and an interval.Example
select timestamp '2021-01-05 12:00:00' + interval '5 days' as "result";
The result will be a new timestamp, adding 5 days to ‘2021-01-05 12:00:00’.
result ---------------------------- 2021-01-10 12:00:00.000000
11. TIMESTAMP - INTERVAL
Subtract an interval from a timestamp.Example
select timestamp '2022-01-04 12:00:00' - interval '3 days' as "result";
In this example, it subtracts 3 days from ‘2022-01-04 12:00:00’.
result ---------------------------- 2022-01-01 12:00:00.000000
12. TIMESTAMP - TIMESTAMP
Get an interval by subtracting one timestamp from another. Example
select timestamp '2022-01-05 18:30:00' - timestamp '2022-01-01 12:00:00' as "result";
It gives the interval between the two timestamps, 102 hours and 30 minutes.
It adds 6 days to 2 days, resulting in a total of 2 months and 8 days.
result --------------- 2 mons 8 days
14. INTERVAL - INTERVAL
Subtract intervals.Example
select interval '2 months' - interval '20 days' as "result";
It subtracts 20 days from 2 months.
result ----------------- 2 mons -20 days
15. INTERVAL * INTEGER
Multiply an interval by an integer.Example
select interval '2 hours' * 3 as "result";
It multiplies ‘2 hours’ by 3, the result is 6 hours.
result ----------------- 06:00:00.000000
16. INTERVAL * DOUBLE PRECISION
Multiply an interval by a scalar.Example
select interval '2 hours' * 1.5 as "result";
It multiplies ‘2 hours’ by 1.5, and returns 3 hours.
result ----------------- 03:00:00.000000
17. INTERVAL / NUMBER
Divide an interval by an integer or scalar.
a) Divide by an integer
select interval '1 hour' / 2 as "result";
It divides ‘1 hour’ by 2, and returns 30 minutes.
result ----------------- 00:30:00.000000
b) Divide by a scalar
select interval '2 hours' / 1.5 as "result";
It divides ‘2 hours’ by 1.5, and returns 1 hour 20 minutes.
result ----------------- 01:20:00.000000
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Oxla Developer Hub","colors":{"primary":"#EEEEEE","light":"#EEEEEE","dark":"#232628"},"logo":{"light":"https://mintcdn.com/oxla/0Js4fLL2Ovp7KANj/assets/images/logo/logo-light.svg?fit=max\u0026auto=format\u0026n=0Js4fLL2Ovp7KANj\u0026q=85\u0026s=4074307a3716643bc058dc994a8cf42f","dark":"https://mintcdn.com/oxla/0Js4fLL2Ovp7KANj/assets/images/logo/logo-dark.svg?fit=max\u0026auto=format\u0026n=0Js4fLL2Ovp7KANj\u0026q=85\u0026s=1dfc90f7bfc27796145623a3c3bc8fa9","href":"https://docs.oxla.com/welcome"},"favicon":"/assets/images/favicon/oxla-favicon.svg","background":{"image":{"light":"https://mintlify.s3.us-west-1.amazonaws.com/oxla/assets/images/light/background/background-light.png","dark":"https://mintlify.s3.us-west-1.amazonaws.com/oxla/assets/images/dark/background/background-dark.png"}},"navbar":{"links":[{"label":"Oxla.com","href":"https://www.oxla.com/"},{"label":"Docker Hub","href":"https://hub.docker.com/r/oxla/oxla"},{"label":"Blog","href":"https://www.oxla.com/blog"}]},"footer":{"socials":{}},"seo":{"metatags":{"og:image":"https://mintlify.s3-us-west-1.amazonaws.com/oxla/assets/images/light/homepage-img-light.png"},"indexing":"navigable"},"banner":{"content":"Oxla has been acquired by Redpanda Data. [ Read the news here.](https://www.redpanda.com/blog/agentic-data-plane-adp)"},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"oxla","hasAudioNarration":false,"actualSubdomain":"oxla","customDomains":["docs.oxla.com"],"gitSource":{"type":"github","owner":"oxlacom","repo":"oxla-docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"entitlements":{"AI_CHAT":{"status":"DISABLED"}},"buildId":"6ae91f38d9cf549fcc2932be:success","clientVersion":"0.0.4270","searchFilterCounts":[{"language":"default","tag":"Development Guide","count":226},{"language":"default","tag":"SQL Reference","count":200},{"language":"default","tag":"SQL Functions","count":133},{"language":"default","tag":"Aggregate","count":33},{"language":"default","tag":"SQL Statements","count":28},{"language":"default","tag":"Other","count":22},{"language":"default","tag":"Statistics","count":19},{"language":"default","tag":"Math","count":19},{"language":"default","tag":"Window","count":19},{"language":"default","tag":"SQL Clauses","count":18}]},"assistantConfig":{},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"site-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"treatment","enabled":true,"payload":{"type":"string","value":"treatment"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":"@tailwind base;@tailwind components;@tailwind utilities;@import url(\"https://fonts.googleapis.com/css2?family=Funnel+Display:wght@300..800\u0026display=swap\");body{font-family:\"Funnel Display\";font-optical-sizing:auto;font-style:normal}.dark p{color:rgb(255, 255, 255)}:is(.dark .dark\\:bg-codeblock\\/50){filter:brightness()}:is(.dark .dark\\:bg-codeblock\\/50) svg{filter:brightness(10)}:is(.dark .dark\\:bg-codeblock\\/50):hover{filter:brightness(10)}:is(.dark\\:text-primary-light){color:#694AFE}:is(.dark .dark\\:text-primary-light){color:#694AFE}.prose:is(.dark *){color:white}.prose{color:black}:not(pre)>code:is(.dark *){background:#3C4043;border-width:0}:not(pre)>code{background:#CCCCCC;color:black;border-width:0}.prose a{color:#FF4C4C;text-decoration:none;border-bottom:1px solid #FF4C4C;transition:color 0.3s, border-bottom-width 0.1s, font-weight 0.1s}:is(.dark) .prose a{color:#FF4C4C;text-decoration:none;border-bottom:1px solid #FF4C4C;transition:color 0.3s, border-bottom-width 0.1s, font-weight 0.1s}.prose a:hover,.prose a:focus{color:#FF4C4C;border-bottom-width:2px;font-weight:900;outline:none}:is(.dark) .prose a:hover,:is(.dark) .prose a:focus{color:#FF4C4C;border-bottom-width:2px;font-weight:900;outline:none}.prose a:visited{color:#FF4C4C}:is(.dark) .prose a:visited{color:#FF4C4C}.card{background-color:#FAFAFA;border:2px solid #232628;box-shadow:0 4px 8px rgb(0, 0, 0, 0.2);border-radius:8px;padding:5px;transition:0.3s}:is(.dark) .card{background-color:#232628;border:2px solid #606263;box-shadow:0 4px 8px rgb(0, 0, 0, 0.2);border-radius:8px;padding:5px;transition:0.3s}"}]}
{"page":{"pagePath":"sql-reference/sql-data-types/time-type/time-operators","slug":"/sql-reference/sql-data-types/time-type/time-operators","pageMetadata":{"title":"Time Operators","createdAt":"2024-01-04T15:40:00.270Z","updatedAt":"2024-01-04T15:50:08.654Z","description":null,"href":"/sql-reference/sql-data-types/time-type/time-operators"},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={code:`code`,p:`p`,pre:`pre`,span:`span`,strong:`strong`,..._provideComponents(),...props.components},{CodeBlock,Heading}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Heading)_missingMdxReference(`Heading`,true);return _jsxs(_Fragment,{children:[_jsx(_components.p,{children:`Time operators in Oxla allow you to perform various operations on dates, times, and intervals. Here’s a guide to using these operators:`}),`\n`,_jsx(Heading,{level:`2`,id:`1-date-+-integer`,children:`1. DATE + INTEGER`}),`\n`,_jsx(_components.p,{children:`Add a specific number of days to a date.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Example`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` date`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '2022-03-15'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` +`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 14`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` as`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`The result will be 14 days after ‘2022-03-15’.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`------------`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 2022`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`-`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`03`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`-`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`29`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`3`,id:`1-1-integer-+-date`,children:`1.1. INTEGER + DATE`}),`\n`,_jsxs(_components.p,{children:[`Adding and multiplying time operators can also be done in reverse order. For example, we add a number of days to a date in the format of `,_jsx(_components.code,{children:`Integer + Date`}),`.`]}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 14`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` +`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` date`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '2022-03-15'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` AS`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`The result will be the same, which is 14 days after ‘2022-03-15’ is ‘2022-03-29’.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`------------`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 2022`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`-`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`03`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`-`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`29`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`2-date-+-interval`,children:`2. DATE + INTERVAL`}),`\n`,_jsx(_components.p,{children:`Add a specified interval to a date.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Example`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` date`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '2022-03-15'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` +`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` interval `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'3 months'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` as`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`The result will be the date three months after ‘2022-03-15’.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`----------------------------`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 2022`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`-`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`06`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`-`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`15`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`000000`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`3-date-integer`,children:`3. DATE - INTEGER`}),`\n`,_jsx(_components.p,{children:`Subtract a certain number of days from a date.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Example`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` date`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '2022-03-15'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` -`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 7`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` as`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`The result will be 7 days before ‘2022-03-15’.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`------------`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 2022`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`-`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`03`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`-`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`08`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`4-date-interval`,children:`4. DATE - INTERVAL`}),`\n`,_jsx(_components.p,{children:`Subtract a specified interval from a date.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Example`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` date`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '2022-03-15'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` -`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` interval `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'2 hour'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` as`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`The result will be the timestamp with two hours before ‘2022-03-15’.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`----------------------------`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 2022`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`-`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`03`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`-`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`14`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 22`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`000000`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`5-date-date`,children:`5. DATE - DATE`}),`\n`,_jsx(_components.p,{children:`Subtract dates.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Example`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` date`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '2023-03-15'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` -`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` date`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '2023-01-10'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` as`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`The number of days elapsed between ‘2023-03-15’ and ‘2023-01-10’ is 64 days.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`--------`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 64`})}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`6-date-+-time`,children:`6. DATE + TIME`}),`\n`,_jsx(_components.p,{children:`Add a time-of-day to a date.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Example`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` date`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '2010-05-20'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` +`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` time`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '02:00'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` as`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`The result will be a timestamp with the specified time added to the given date.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`----------------------------`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 2010`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`-`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`05`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`-`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`20`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 02`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`000000`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`7-time-+-interval`,children:`7. TIME + INTERVAL`}),`\n`,_jsx(_components.p,{children:`Add a certain interval to a given time.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Example`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` time`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '12:30'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` +`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` interval `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'1 hour'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` as`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`The result will be the time 1 hour after ‘12:30’.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`-----------------`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 13`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`30`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`000000`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`8-time-interval`,children:`8. TIME - INTERVAL`}),`\n`,_jsx(_components.p,{children:`Subtract a specified interval from a given time.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Example`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` time`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '18:45'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` -`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` interval `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'45 minutes'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` as`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`The result will be the time 18:00.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`-----------------`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 18`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`000000`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`9-time-time`,children:`9. TIME - TIME`}),`\n`,_jsx(_components.p,{children:`Get a time difference by subtracting one time from another.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Example`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` time`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '10:00'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` -`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` TIME`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '08:20'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` as`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`In this example, the time difference between the two provided times is 1 hour and 40 minutes.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`-----------------`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 01`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`40`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`000000`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`10-timestamp-+-interval`,children:`10. TIMESTAMP + INTERVAL`}),`\n`,_jsx(_components.p,{children:`Add a timestamp and an interval.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Example`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` timestamp`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '2021-01-05 12:00:00'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` +`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` interval `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'5 days'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` as`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`The result will be a new timestamp, adding 5 days to ‘2021-01-05 12:00:00’.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`----------------------------`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 2021`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`-`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`01`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`-`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`10`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 12`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`000000`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`11-timestamp-interval`,children:`11. TIMESTAMP - INTERVAL`}),`\n`,_jsx(_components.p,{children:`Subtract an interval from a timestamp.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Example`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` timestamp`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '2022-01-04 12:00:00'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` -`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` interval `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'3 days'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` as`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`In this example, it subtracts 3 days from ‘2022-01-04 12:00:00’.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`----------------------------`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 2022`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`-`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`01`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`-`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`01`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 12`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`000000`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`12-timestamp-timestamp`,children:`12. TIMESTAMP - TIMESTAMP`}),`\n`,_jsx(_components.p,{children:`Get an interval by subtracting one timestamp from another. `}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Example`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` timestamp`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '2022-01-05 18:30:00'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` -`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` timestamp`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '2022-01-01 12:00:00'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` as`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`It gives the interval between the two timestamps, 102 hours and 30 minutes.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`------------------`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 102`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`30`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`000000`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`13-interval-+-interval`,children:`13. INTERVAL + INTERVAL`}),`\n`,_jsx(_components.p,{children:`Add intervals.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Example`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` interval `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'2 months 2 days'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` +`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` interval `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'6 days'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` as`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`It adds 6 days to 2 days, resulting in a total of 2 months and 8 days.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`---------------`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 2`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` mons `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`8`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` days`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`14-interval-interval`,children:`14. INTERVAL - INTERVAL`}),`\n`,_jsx(_components.p,{children:`Subtract intervals.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Example`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` interval `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'2 months'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` -`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` interval `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'20 days'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` as`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`It subtracts 20 days from 2 months.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`-----------------`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 2`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` mons `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`-`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`20`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` days`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`15-interval-integer`,children:`15. INTERVAL * INTEGER`}),`\n`,_jsx(_components.p,{children:`Multiply an interval by an integer.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Example`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` interval `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'2 hours'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` *`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 3`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` as`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`It multiplies ‘2 hours’ by 3, the result is 6 hours.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`-----------------`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 06`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`000000`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`16-interval-double-precision`,children:`16. INTERVAL * DOUBLE PRECISION`}),`\n`,_jsx(_components.p,{children:`Multiply an interval by a scalar.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Example`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` interval `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'2 hours'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` *`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 1`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`5`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` as`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`It multiplies ‘2 hours’ by 1.5, and returns 3 hours.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`-----------------`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 03`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`000000`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`17-interval-/-number`,children:`17. INTERVAL / NUMBER`}),`\n`,_jsx(_components.p,{children:`Divide an interval by an integer or scalar.`}),`\n`,_jsx(Heading,{level:`3`,id:`a-divide-by-an-integer`,children:`a) Divide by an integer`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` interval `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'1 hour'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` /`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 2`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` as`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`It divides ‘1 hour’ by 2, and returns 30 minutes.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`-----------------`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`30`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`000000`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`3`,id:`b-divide-by-a-scalar`,children:`b) Divide by a scalar`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`select`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` interval `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'2 hours'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` /`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 1`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`5`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` as`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"result\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`It divides ‘2 hours’ by 1.5, and returns 1 hour 20 minutes.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`3`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`-----------------`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 01`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`20`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`00`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`000000`})]}),`\n`]})})})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Time Operators","createdAt":"2024-01-04T15:40:00.270Z","updatedAt":"2024-01-04T15:50:08.654Z","description":null,"href":"/sql-reference/sql-data-types/time-type/time-operators"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"1. DATE + INTEGER","slug":"1-date-+-integer","depth":2,"children":[{"title":"1.1. INTEGER + DATE","slug":"1-1-integer-+-date","depth":3,"children":[]}]},{"title":"2. DATE + INTERVAL","slug":"2-date-+-interval","depth":2,"children":[]},{"title":"3. DATE - INTEGER","slug":"3-date-integer","depth":2,"children":[]},{"title":"4. DATE - INTERVAL","slug":"4-date-interval","depth":2,"children":[]},{"title":"5. DATE - DATE","slug":"5-date-date","depth":2,"children":[]},{"title":"6. DATE + TIME","slug":"6-date-+-time","depth":2,"children":[]},{"title":"7. TIME + INTERVAL","slug":"7-time-+-interval","depth":2,"children":[]},{"title":"8. TIME - INTERVAL","slug":"8-time-interval","depth":2,"children":[]},{"title":"9. TIME - TIME","slug":"9-time-time","depth":2,"children":[]},{"title":"10. TIMESTAMP + INTERVAL","slug":"10-timestamp-+-interval","depth":2,"children":[]},{"title":"11. TIMESTAMP - INTERVAL","slug":"11-timestamp-interval","depth":2,"children":[]},{"title":"12. TIMESTAMP - TIMESTAMP","slug":"12-timestamp-timestamp","depth":2,"children":[]},{"title":"13. INTERVAL + INTERVAL","slug":"13-interval-+-interval","depth":2,"children":[]},{"title":"14. INTERVAL - INTERVAL","slug":"14-interval-interval","depth":2,"children":[]},{"title":"15. INTERVAL * INTEGER","slug":"15-interval-integer","depth":2,"children":[]},{"title":"16. INTERVAL * DOUBLE PRECISION","slug":"16-interval-double-precision","depth":2,"children":[]},{"title":"17. INTERVAL / NUMBER","slug":"17-interval-/-number","depth":2,"children":[{"title":"a) Divide by an integer","slug":"a-divide-by-an-integer","depth":3,"children":[]},{"title":"b) Divide by a scalar","slug":"b-divide-by-a-scalar","depth":3,"children":[]}]}],"codeExamples":{}},"jsLinks":[],"subdomain":"oxla","siteName":"Oxla Developer Hub","title":"Time Operators - Oxla Developer Hub","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2025-10-28T08:12:52.823Z","originalFileLocation":"sql-reference/sql-data-types/time-type/time-operators.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"application-name\" content=\"Oxla Developer Hub\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/oxla/NKLUScSyRMjD1PxQ/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/oxla/NKLUScSyRMjD1PxQ/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/oxla/NKLUScSyRMjD1PxQ/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/oxla/NKLUScSyRMjD1PxQ/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/oxla/NKLUScSyRMjD1PxQ/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/oxla/NKLUScSyRMjD1PxQ/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/oxla/NKLUScSyRMjD1PxQ/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/oxla/NKLUScSyRMjD1PxQ/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/oxla/NKLUScSyRMjD1PxQ/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Time Operators - Oxla Developer Hub\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Oxla Developer Hub\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.oxla.com/sql-reference/sql-data-types/time-type/time-operators\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://mintlify.s3-us-west-1.amazonaws.com/oxla/assets/images/light/homepage-img-light.png\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Time Operators - Oxla Developer Hub\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://mintlify.s3-us-west-1.amazonaws.com/oxla/assets/images/light/homepage-img-light.png\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/oxla/NKLUScSyRMjD1PxQ/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Oxla Developer Hub\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#EEEEEE\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.oxla.com/sql-reference/sql-data-types/time-type/time-operators\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/sql-reference/sql-data-types/time-type/time-operators.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.oxla.com/#organization\",\"name\":\"Oxla Developer Hub\",\"url\":\"https://docs.oxla.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/oxla/0Js4fLL2Ovp7KANj/assets/images/logo/logo-light.svg?fit=max\u0026auto=format\u0026n=0Js4fLL2Ovp7KANj\u0026q=85\u0026s=4074307a3716643bc058dc994a8cf42f\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.oxla.com#website\",\"name\":\"Oxla Developer Hub\",\"url\":\"https://docs.oxla.com\",\"publisher\":{\"@id\":\"https://docs.oxla.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.oxla.com/sql-reference/sql-data-types/time-type/time-operators#webpage\",\"url\":\"https://docs.oxla.com/sql-reference/sql-data-types/time-type/time-operators\",\"name\":\"Time Operators\",\"dateModified\":\"2025-10-28T08:12:52.823Z\",\"isPartOf\":{\"@id\":\"https://docs.oxla.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.oxla.com/sql-reference/sql-data-types/time-type/time-operators#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.oxla.com/sql-reference/sql-data-types/time-type/time-operators#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Development Guide\",\"item\":\"https://docs.oxla.com/sql-reference/overview\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Reference\",\"item\":\"https://docs.oxla.com/sql-reference/overview\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQL Data Types\",\"item\":\"https://docs.oxla.com/sql-reference/sql-data-types/overview\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Time\",\"item\":\"https://docs.oxla.com/sql-reference/sql-data-types/time-type/time\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Time Operators\",\"item\":\"https://docs.oxla.com/sql-reference/sql-data-types/time-type/time-operators\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.oxla.com/sql-reference/sql-data-types/time-type/time-operators#article\",\"headline\":\"Time Operators\",\"name\":\"Time Operators\",\"url\":\"https://docs.oxla.com/sql-reference/sql-data-types/time-type/time-operators\",\"mainEntityOfPage\":{\"@id\":\"https://docs.oxla.com/sql-reference/sql-data-types/time-type/time-operators#webpage\"},\"image\":\"https://mintlify.s3-us-west-1.amazonaws.com/oxla/assets/images/light/homepage-img-light.png\",\"dateModified\":\"2025-10-28T08:12:52.823Z\",\"publisher\":{\"@id\":\"https://docs.oxla.com/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.oxla.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Oxla Developer Hub\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Oxla Developer Hub\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/sql-reference/sql-data-types/time-type/time-operators.md","siteName":"Oxla Developer Hub","nav":{"global":null,"groups":[{"group":"Home","pages":[{"title":"Welcome","href":"/welcome"}]},{"group":"Introduction","pages":[{"title":"What is Oxla and why use it","href":"/introduction/what-is-oxla-and-why-use-it"}]},{"group":"Development Guide","pages":[{"group":"SQL Reference","pages":[{"title":"SQL Reference","sidebarTitle":"Overview","href":"/sql-reference/overview"},{"group":"SQL Statements","pages":[{"title":"SQL STATEMENTS","sidebarTitle":"Overview","href":"/sql-reference/sql-statements/overview"},{"title":"SELECT","href":"/sql-reference/sql-statements/select"},{"title":"INSERT INTO","href":"/sql-reference/sql-statements/insert-into"},{"group":"COPY FROM","pages":[{"title":"COPY FROM","href":"/sql-reference/sql-statements/copy-from/copy-from"},{"title":"COPY FROM with Delimiter","href":"/sql-reference/sql-statements/copy-from/copy-from-with-delimiter"},{"title":"COPY FROM with Endpoint","href":"/sql-reference/sql-statements/copy-from/copy-from-with-endpoint"},{"title":"COPY FROM with HEADER","href":"/sql-reference/sql-statements/copy-from/copy-from-with-header"},{"title":"COPY FROM with NULL","href":"/sql-reference/sql-statements/copy-from/copy-from-with-null"},{"title":"COPY FROM with FORMAT","href":"/sql-reference/sql-statements/copy-from/copy-from-with-format"},{"title":"Importing Data from a CSV file","sidebarTitle":"COPY FROM CSV","href":"/sql-reference/sql-statements/copy-from/copy-from-csv"},{"title":"Importing Data from a ORC file","sidebarTitle":"COPY FROM ORC","href":"/sql-reference/sql-statements/copy-from/copy-from-orc"},{"title":"Importing Data from a Parquet file","sidebarTitle":"COPY FROM PARQUET","href":"/sql-reference/sql-statements/copy-from/copy-from-parquet"},{"title":"COPY FROM STDIN","href":"/sql-reference/sql-statements/copy-from/copy-from-stdin"}]},{"group":"COPY TO","pages":[{"title":"COPY TO","href":"/sql-reference/sql-statements/copy-to/copy-to"},{"title":"Export Data to a CSV file","sidebarTitle":"COPY TO CSV","href":"/sql-reference/sql-statements/copy-to/copy-to-csv"},{"title":"COPY TO with Delimiter","href":"/sql-reference/sql-statements/copy-to/copy-to-with-delimiter"},{"title":"COPY TO with Endpoint","href":"/sql-reference/sql-statements/copy-to/copy-to-with-endpoint"},{"title":"COPY TO with HEADER","href":"/sql-reference/sql-statements/copy-to/copy-to-with-header"},{"title":"COPY TO with NULL","href":"/sql-reference/sql-statements/copy-to/copy-to-with-null"},{"title":"COPY TO STDOUT","href":"/sql-reference/sql-statements/copy-to/copy-to-stdout"}]},{"title":"CREATE INDEX","href":"/sql-reference/sql-statements/create-index"},{"title":"CREATE TABLE","href":"/sql-reference/sql-statements/create-table"},{"title":"DESCRIBE","href":"/sql-reference/sql-statements/describe"},{"title":"DROP","href":"/sql-reference/sql-statements/drop"},{"title":"SET/SHOW","href":"/sql-reference/sql-statements/set-show"},{"title":"SHOW TABLES","href":"/sql-reference/sql-statements/show-tables"},{"title":"SHOW NODES","href":"/sql-reference/sql-statements/show-nodes"},{"title":"Keywords","href":"/sql-reference/sql-statements/keywords"}]},{"group":"SQL Mutations","pages":[{"title":"SQL MUTATIONS","sidebarTitle":"Overview","href":"/sql-reference/sql-mutations/overview"},{"title":"UPDATE","href":"/sql-reference/sql-mutations/update"},{"title":"DELETE","href":"/sql-reference/sql-mutations/delete"}]},{"group":"SQL Clauses","pages":[{"title":"SQL CLAUSES","sidebarTitle":"Overview","href":"/sql-reference/sql-clauses/overview"},{"group":"FROM","pages":[{"title":"FROM","href":"/sql-reference/sql-clauses/from/from"},{"title":"JOIN","href":"/sql-reference/sql-clauses/from/join"},{"title":"LEFT JOIN","href":"/sql-reference/sql-clauses/from/left-join"},{"title":"OUTER JOIN","href":"/sql-reference/sql-clauses/from/outer-join"},{"title":"RIGHT JOIN","href":"/sql-reference/sql-clauses/from/right-join"}]},{"title":"WHERE","href":"/sql-reference/sql-clauses/where"},{"title":"GROUP BY","href":"/sql-reference/sql-clauses/group-by"},{"title":"HAVING","href":"/sql-reference/sql-clauses/having"},{"title":"ORDER BY","href":"/sql-reference/sql-clauses/order-by"},{"title":"LIMIT","href":"/sql-reference/sql-clauses/limit"},{"title":"OFFSET","href":"/sql-reference/sql-clauses/offset"},{"group":"Set Operations","pages":[{"title":"Overview","href":"/sql-reference/sql-clauses/set-operations/overview"},{"title":"EXCEPT","href":"/sql-reference/sql-clauses/set-operations/except"},{"title":"INTERSECT","href":"/sql-reference/sql-clauses/set-operations/intersect"},{"title":"UNION","href":"/sql-reference/sql-clauses/set-operations/union"}]},{"title":"WITH","href":"/sql-reference/sql-clauses/with"},{"title":"OVER / WINDOW","href":"/sql-reference/sql-clauses/over-window"}]},{"group":"SQL Data Types","pages":[{"title":"SQL DATA TYPES","sidebarTitle":"Overview","href":"/sql-reference/sql-data-types/overview"},{"title":"Data Type Operators","href":"/sql-reference/sql-data-types/data-type-operators"},{"group":"Numeric","pages":[{"title":"Numeric","href":"/sql-reference/sql-data-types/numeric-type/numeric"},{"title":"Numeric Data Type - Aliases","href":"/sql-reference/sql-data-types/numeric-type/numeric-data-type-aliases"}]},{"title":"Timestamp Without Time Zone","href":"/sql-reference/sql-data-types/timestamp-without-time-zone"},{"title":"Timestamp with Time Zone","href":"/sql-reference/sql-data-types/timestamp-with-time-zone"},{"title":"Date","href":"/sql-reference/sql-data-types/date"},{"group":"Time","pages":[{"title":"Time","description":null,"href":"/sql-reference/sql-data-types/time-type/time"},{"title":"Time Operators","href":"/sql-reference/sql-data-types/time-type/time-operators"}]},{"title":"Interval","description":null,"href":"/sql-reference/sql-data-types/interval"},{"title":"Bool","href":"/sql-reference/sql-data-types/bool"},{"title":"Text","href":"/sql-reference/sql-data-types/text"},{"title":"JSON","href":"/sql-reference/sql-data-types/json"},{"title":"Array","href":"/sql-reference/sql-data-types/array"}]},{"group":"SQL Functions","pages":[{"title":"SQL Functions","sidebarTitle":"Overview","href":"/sql-reference/sql-functions/overview"},{"group":"Boolean","pages":[{"title":"IF Function","href":"/sql-reference/sql-functions/boolean-functions/if-function"},{"title":"IS DISTINCT FROM Operator","href":"/sql-reference/sql-functions/boolean-functions/is-distinct-from-operator"},{"title":"IS NOT DISTINCT FROM Operator","href":"/sql-reference/sql-functions/boolean-functions/is-not-distinct-from-operator"}]},{"group":"Math","pages":[{"title":"Overview","href":"/sql-reference/sql-functions/math-functions/overview"},{"title":"ABS","href":"/sql-reference/sql-functions/math-functions/abs"},{"title":"CBRT","href":"/sql-reference/sql-functions/math-functions/cbrt"},{"title":"CEIL","href":"/sql-reference/sql-functions/math-functions/ceil"},{"title":"EXP","href":"/sql-reference/sql-functions/math-functions/exp"},{"title":"FLOOR","href":"/sql-reference/sql-functions/math-functions/floor"},{"title":"GREATEST","href":"/sql-reference/sql-functions/math-functions/greatest"},{"title":"LEAST","href":"/sql-reference/sql-functions/math-functions/least"},{"title":"LN","href":"/sql-reference/sql-functions/math-functions/ln"},{"title":"LOG","href":"/sql-reference/sql-functions/math-functions/log"},{"title":"POWER","href":"/sql-reference/sql-functions/math-functions/power"},{"title":"RANDOM","href":"/sql-reference/sql-functions/math-functions/random"},{"title":"ROUND","href":"/sql-reference/sql-functions/math-functions/round"},{"title":"SIGN","href":"/sql-reference/sql-functions/math-functions/sign"},{"title":"SIN","href":"/sql-reference/sql-functions/math-functions/sin"},{"title":"SQRT","href":"/sql-reference/sql-functions/math-functions/sqrt"},{"title":"BITWISE SHIFT LEFT","sidebarTitle":"BITWISE SHIFT LEFT","href":"/sql-reference/sql-functions/math-functions/bitwise-shift-left"},{"title":"BITWISE SHIFT RIGHT","sidebarTitle":"BITWISE SHIFT RIGHT","href":"/sql-reference/sql-functions/math-functions/bitwise-shift-right"},{"title":"TO_CHAR from Number","href":"/sql-reference/sql-functions/math-functions/to-char-from-number"}]},{"group":"String","pages":[{"title":"Overview","href":"/sql-reference/sql-functions/string-functions/overview"},{"title":"CONCAT","href":"/sql-reference/sql-functions/string-functions/concat"},{"title":"ENDS_WITH","href":"/sql-reference/sql-functions/string-functions/ends-with"},{"title":"LENGTH","href":"/sql-reference/sql-functions/string-functions/length"},{"title":"LOWER","href":"/sql-reference/sql-functions/string-functions/lower"},{"group":"Regex","pages":[{"title":"REGEXP_REPLACE()","sidebarTitle":"REGEXP_REPLACE","href":"/sql-reference/sql-functions/string-functions/regex/regexp-replace"},{"title":"REGEXP_MATCH()","sidebarTitle":"REGEXP_MATCH","href":"/sql-reference/sql-functions/string-functions/regex/regexp-match"},{"title":"POSIX Regular Expressions","href":"/sql-reference/sql-functions/string-functions/regex/posix-regular-expressions"}]},{"title":"REPLACE()","sidebarTitle":"REPLACE","href":"/sql-reference/sql-functions/string-functions/replace"},{"title":"STARTS_WITH","href":"/sql-reference/sql-functions/string-functions/starts-with"},{"title":"STRPOS","href":"/sql-reference/sql-functions/string-functions/strpos"},{"title":"SUBSTR","href":"/sql-reference/sql-functions/string-functions/substr"},{"title":"SUBSTRING","href":"/sql-reference/sql-functions/string-functions/substring"},{"title":"UPPER","href":"/sql-reference/sql-functions/string-functions/upper"},{"title":"POSITION","href":"/sql-reference/sql-functions/string-functions/position"}]},{"group":"Timestamp","pages":[{"title":"Overview","href":"/sql-reference/sql-functions/timestamp-functions/overview"},{"title":"CURRENT_TIMESTAMP","href":"/sql-reference/sql-functions/timestamp-functions/current-timestamp"},{"title":"DATE_TRUNC","href":"/sql-reference/sql-functions/timestamp-functions/date-trunc"},{"title":"EXTRACT","href":"/sql-reference/sql-functions/timestamp-functions/extract"},{"title":"FORMAT_TIMESTAMP","href":"/sql-reference/sql-functions/timestamp-functions/format-timestamp"},{"title":"TIMESTAMP_MICROS","href":"/sql-reference/sql-functions/timestamp-functions/timestamp-micros"},{"title":"TIMESTAMP_MILLIS","href":"/sql-reference/sql-functions/timestamp-functions/timestamp-millis"},{"title":"TIMESTAMP_SECONDS","href":"/sql-reference/sql-functions/timestamp-functions/timestamp-seconds"},{"title":"TIMESTAMP_TRUNC","href":"/sql-reference/sql-functions/timestamp-functions/timestamp-trunc"},{"title":"TO_CHAR","href":"/sql-reference/sql-functions/timestamp-functions/to-char"},{"title":"TO_TIMESTAMP","href":"/sql-reference/sql-functions/timestamp-functions/to-timestamp"},{"title":"UNIX_MICROS","href":"/sql-reference/sql-functions/timestamp-functions/unix-macros"},{"title":"UNIX_MICROS","href":"/sql-reference/sql-functions/timestamp-functions/unix-micros"},{"title":"UNIX_MILLIS","href":"/sql-reference/sql-functions/timestamp-functions/unix-millis"},{"title":"UNIX_SECONDS","href":"/sql-reference/sql-functions/timestamp-functions/unix-seconds"}]},{"group":"Trigonometric","pages":[{"title":"Trigonometric Functions","href":"/sql-reference/sql-functions/trigonometric-functions/overview"}]},{"group":"JSON","pages":[{"title":"Overview","href":"/sql-reference/sql-functions/json-functions/overview"},{"title":"JSON_ARRAY_EXTRACT","href":"/sql-reference/sql-functions/json-functions/json-array-extract"},{"title":"JSON_ARRAY_LENGTH","href":"/sql-reference/sql-functions/json-functions/json-array-length"},{"title":"JSON_EXTRACT_PATH","href":"/sql-reference/sql-functions/json-functions/json-extract-path"},{"title":"JSON_EXTRACT_PATH_TEXT","href":"/sql-reference/sql-functions/json-functions/json-extract-path-text"}]},{"group":"Aggregate","pages":[{"title":"Overview","href":"/sql-reference/sql-functions/aggregate-functions/overview"},{"group":"Statistics","pages":[{"title":"Overview","href":"/sql-reference/sql-functions/aggregate-functions/overview-statistics"},{"title":"CORR()","sidebarTitle":"CORR","href":"/sql-reference/sql-functions/aggregate-functions/corr"},{"title":"COVAR_POP()","sidebarTitle":"COVAR_POP","href":"/sql-reference/sql-functions/aggregate-functions/covar-pop"},{"title":"COVAR_SAMP","href":"/sql-reference/sql-functions/aggregate-functions/covar-samp"},{"title":"REGR_AVGX()","sidebarTitle":"REGR_AVGX","href":"/sql-reference/sql-functions/aggregate-functions/regr-avgx"},{"title":"REGR_AVGY()","sidebarTitle":"REGR_AVGY","href":"/sql-reference/sql-functions/aggregate-functions/regr-avgy"},{"title":"REGR_COUNT()","sidebarTitle":"REGR_COUNT","href":"/sql-reference/sql-functions/aggregate-functions/regr-count"},{"title":"REGR_INTERCEPT()","sidebarTitle":"REGR_INTERCEPT","href":"/sql-reference/sql-functions/aggregate-functions/regr-intercept"},{"title":"REGR_R2()","sidebarTitle":"REGR_R2","href":"/sql-reference/sql-functions/aggregate-functions/regr-r2"},{"title":"REGR_SLOPE()","sidebarTitle":"REGR_SLOPE","href":"/sql-reference/sql-functions/aggregate-functions/regr-slope"},{"title":"REGR_SXX()","sidebarTitle":"REGR_SXX","href":"/sql-reference/sql-functions/aggregate-functions/regr-sxx"},{"title":"REGR_SXY()","sidebarTitle":"REGR_SXY","href":"/sql-reference/sql-functions/aggregate-functions/regr-sxy"},{"title":"REGR_SYY()","sidebarTitle":"REGR_SYY","href":"/sql-reference/sql-functions/aggregate-functions/regr-syy"},{"title":"STDDEV()","sidebarTitle":"STDDEV","href":"/sql-reference/sql-functions/aggregate-functions/stddev"},{"title":"STDDEV_POP()","sidebarTitle":"STDDEV_POP","href":"/sql-reference/sql-functions/aggregate-functions/stddev-pop"},{"title":"STDDEV_SAMP()","sidebarTitle":"STDDEV_SAMP","href":"/sql-reference/sql-functions/aggregate-functions/stddev-samp"},{"title":"VARIANCE()","sidebarTitle":"VARIANCE","href":"/sql-reference/sql-functions/aggregate-functions/variance"},{"title":"VAR_POP()","sidebarTitle":"VAR_POP","href":"/sql-reference/sql-functions/aggregate-functions/var-pop"},{"title":"VAR_SAMP()","sidebarTitle":"VAR_SAMP","href":"/sql-reference/sql-functions/aggregate-functions/var-samp"}]},{"group":"Ordered-Set","pages":[{"title":"MODE()","sidebarTitle":"MODE","href":"/sql-reference/sql-functions/aggregate-functions/ordered-set-aggregate-functions/mode"},{"title":"PERCENTILE_CONT()","sidebarTitle":"PERCENTILE_CONT","href":"/sql-reference/sql-functions/aggregate-functions/ordered-set-aggregate-functions/percentile-cont"},{"title":"PERCENTILE_DISC()","sidebarTitle":"PERCENTILE_DISC","href":"/sql-reference/sql-functions/aggregate-functions/ordered-set-aggregate-functions/percentile-disc"}]},{"title":"AVG","href":"/sql-reference/sql-functions/aggregate-functions/avg"},{"title":"BOOL_AND","href":"/sql-reference/sql-functions/aggregate-functions/bool-and"},{"title":"BOOL_OR","href":"/sql-reference/sql-functions/aggregate-functions/bool-or"},{"title":"COUNT","href":"/sql-reference/sql-functions/aggregate-functions/count"},{"title":"FOR_MAX()","sidebarTitle":"FOR_MAX","href":"/sql-reference/sql-functions/aggregate-functions/for-max"},{"title":"FOR_MIN()","sidebarTitle":"FOR_MIN","href":"/sql-reference/sql-functions/aggregate-functions/for-min"},{"title":"MAX","href":"/sql-reference/sql-functions/aggregate-functions/max"},{"title":"MIN","href":"/sql-reference/sql-functions/aggregate-functions/min"},{"title":"SUM","href":"/sql-reference/sql-functions/aggregate-functions/sum"},{"title":"DISTINCT","href":"/sql-reference/sql-functions/aggregate-functions/distinct"}]},{"group":"Window","pages":[{"title":"Overview","href":"/sql-reference/sql-functions/window-functions/overview"},{"title":"COUNT()","sidebarTitle":"COUNT","href":"/sql-reference/sql-functions/window-functions/count"},{"title":"DENSE_RANK()","sidebarTitle":"DENSE_RANK","href":"/sql-reference/sql-functions/window-functions/dense-rank"},{"title":"RANK()","sidebarTitle":"RANK","href":"/sql-reference/sql-functions/window-functions/rank"},{"title":"ROW_NUMBER","href":"/sql-reference/sql-functions/window-functions/row-number"},{"title":"AVG()","sidebarTitle":"AVG","href":"/sql-reference/sql-functions/window-functions/avg"},{"title":"BOOL_AND()","sidebarTitle":"BOOL_AND","href":"/sql-reference/sql-functions/window-functions/bool-and"},{"title":"BOOL_OR()","sidebarTitle":"BOOL_OR","href":"/sql-reference/sql-functions/window-functions/bool-or"},{"title":"CUME_DIST()","sidebarTitle":"CUME_DIST","href":"/sql-reference/sql-functions/window-functions/cume-dist"},{"title":"FIRST_VALUE()","sidebarTitle":"FIRST_VALUE","href":"/sql-reference/sql-functions/window-functions/first-value"},{"title":"LAG()","sidebarTitle":"LAG","href":"/sql-reference/sql-functions/window-functions/lag"},{"title":"LAST_VALUE()","sidebarTitle":"LAST_VALUE","href":"/sql-reference/sql-functions/window-functions/last-value"},{"title":"LEAD()","sidebarTitle":"LEAD","href":"/sql-reference/sql-functions/window-functions/lead"},{"title":"MAX()","sidebarTitle":"MAX","href":"/sql-reference/sql-functions/window-functions/max"},{"title":"MIN()","sidebarTitle":"MIN","href":"/sql-reference/sql-functions/window-functions/min"},{"title":"NTH_VALUE()","sidebarTitle":"NTH_VALUE","href":"/sql-reference/sql-functions/window-functions/nth-value"},{"title":"NTILE()","sidebarTitle":"NTILE","href":"/sql-reference/sql-functions/window-functions/ntile"},{"title":"PERCENT_RANK()","sidebarTitle":"PERCENT_RANK","href":"/sql-reference/sql-functions/window-functions/percent-rank"},{"title":"SUM()","sidebarTitle":"SUM","href":"/sql-reference/sql-functions/window-functions/sum"}]},{"group":"String","pages":[{"group":"REGEX","pages":[{"title":"REGEXP_REPLACE()","sidebarTitle":"REGEXP_REPLACE","href":"/sql-reference/sql-functions/string-functions/regex/regexp-replace"},{"title":"REGEXP_MATCH()","sidebarTitle":"REGEXP_MATCH","href":"/sql-reference/sql-functions/string-functions/regex/regexp-match"},{"title":"POSIX Regular Expressions","href":"/sql-reference/sql-functions/string-functions/regex/posix-regular-expressions"}]},{"title":"Overview","href":"/sql-reference/sql-functions/string-functions/overview"},{"title":"CONCAT","href":"/sql-reference/sql-functions/string-functions/concat"},{"title":"ENDS_WITH","href":"/sql-reference/sql-functions/string-functions/ends-with"},{"title":"LENGTH","href":"/sql-reference/sql-functions/string-functions/length"},{"title":"LOWER","href":"/sql-reference/sql-functions/string-functions/lower"},{"title":"REPLACE()","sidebarTitle":"REPLACE","href":"/sql-reference/sql-functions/string-functions/replace"},{"title":"STARTS_WITH","href":"/sql-reference/sql-functions/string-functions/starts-with"},{"title":"STRPOS","href":"/sql-reference/sql-functions/string-functions/strpos"},{"title":"SUBSTR","href":"/sql-reference/sql-functions/string-functions/substr"},{"title":"SUBSTRING","href":"/sql-reference/sql-functions/string-functions/substring"},{"title":"UPPER","href":"/sql-reference/sql-functions/string-functions/upper"},{"title":"POSITION","href":"/sql-reference/sql-functions/string-functions/position"}]},{"group":"Timestamp","pages":[{"title":"Overview","href":"/sql-reference/sql-functions/timestamp-functions/overview"},{"title":"CURRENT_TIMESTAMP","href":"/sql-reference/sql-functions/timestamp-functions/current-timestamp"},{"title":"DATE_TRUNC","href":"/sql-reference/sql-functions/timestamp-functions/date-trunc"},{"title":"EXTRACT","href":"/sql-reference/sql-functions/timestamp-functions/extract"},{"title":"FORMAT_TIMESTAMP","href":"/sql-reference/sql-functions/timestamp-functions/format-timestamp"},{"title":"TIMESTAMP_MICROS","href":"/sql-reference/sql-functions/timestamp-functions/timestamp-micros"},{"title":"TIMESTAMP_MILLIS","href":"/sql-reference/sql-functions/timestamp-functions/timestamp-millis"},{"title":"TIMESTAMP_SECONDS","href":"/sql-reference/sql-functions/timestamp-functions/timestamp-seconds"},{"title":"TIMESTAMP_TRUNC","href":"/sql-reference/sql-functions/timestamp-functions/timestamp-trunc"},{"title":"TO_CHAR","href":"/sql-reference/sql-functions/timestamp-functions/to-char"},{"title":"TO_TIMESTAMP","href":"/sql-reference/sql-functions/timestamp-functions/to-timestamp"},{"title":"UNIX_MICROS","href":"/sql-reference/sql-functions/timestamp-functions/unix-macros"},{"title":"UNIX_MICROS","href":"/sql-reference/sql-functions/timestamp-functions/unix-micros"},{"title":"UNIX_MILLIS","href":"/sql-reference/sql-functions/timestamp-functions/unix-millis"},{"title":"UNIX_SECONDS","href":"/sql-reference/sql-functions/timestamp-functions/unix-seconds"}]},{"group":"Boolean","pages":[{"title":"IF Function","href":"/sql-reference/sql-functions/boolean-functions/if-function"},{"title":"IS DISTINCT FROM Operator","href":"/sql-reference/sql-functions/boolean-functions/is-distinct-from-operator"},{"title":"IS NOT DISTINCT FROM Operator","href":"/sql-reference/sql-functions/boolean-functions/is-not-distinct-from-operator"}]},{"group":"JSON","pages":[{"title":"Overview","href":"/sql-reference/sql-functions/json-functions/overview"},{"title":"JSON_ARRAY_EXTRACT","href":"/sql-reference/sql-functions/json-functions/json-array-extract"},{"title":"JSON_ARRAY_LENGTH","href":"/sql-reference/sql-functions/json-functions/json-array-length"},{"title":"JSON_EXTRACT_PATH","href":"/sql-reference/sql-functions/json-functions/json-extract-path"},{"title":"JSON_EXTRACT_PATH_TEXT","href":"/sql-reference/sql-functions/json-functions/json-extract-path-text"}]},{"group":"Other","pages":[{"title":"Overview","href":"/sql-reference/sql-functions/other-functions/overview"},{"title":"coalesce()","sidebarTitle":"coalesce","href":"/sql-reference/sql-functions/other-functions/coalesce"},{"title":"current_database()","sidebarTitle":"current_database","href":"/sql-reference/sql-functions/other-functions/current-database"},{"title":"current_schema()","sidebarTitle":"current_schema","href":"/sql-reference/sql-functions/other-functions/current-schema"},{"title":"has_schema_privilege()","sidebarTitle":"has_schema_privilege","href":"/sql-reference/sql-functions/other-functions/has-schema-privillege"},{"title":"nullif()","sidebarTitle":"nullif","href":"/sql-reference/sql-functions/other-functions/nullif"},{"title":"pg_get_expr()","sidebarTitle":"pg_get_expr","href":"/sql-reference/sql-functions/other-functions/pg-get-expr"},{"title":"pg_total_relation_size()","sidebarTitle":"pg_total_relation_size","href":"/sql-reference/sql-functions/other-functions/pg-total-relation-size"},{"title":"pg_typeof()","sidebarTitle":"pg_typeof","href":"/sql-reference/sql-functions/other-functions/pg-typeof"},{"title":"col_description()","sidebarTitle":"col_description","href":"/sql-reference/sql-functions/other-functions/col-description"},{"title":"pg_get_constraintdef()","sidebarTitle":"pg_get_constraintdef","href":"/sql-reference/sql-functions/other-functions/pg-get-constraintdef"},{"title":"pg_table_is_visible()","sidebarTitle":"pg_table_is_visible","href":"/sql-reference/sql-functions/other-functions/pg-table-is-visible"},{"title":"pg_size_pretty()","sidebarTitle":"pg_size_pretty","href":"/sql-reference/sql-functions/other-functions/pg-size-pretty"},{"title":"obj_description()","sidebarTitle":"obj_description","href":"/sql-reference/sql-functions/other-functions/obj-description"},{"title":"pg_table_size()","sidebarTitle":"pg_table_size","href":"/sql-reference/sql-functions/other-functions/pg-table-size"},{"title":"pg_get_indexdef()","sidebarTitle":"pg_get_indexdef","href":"/sql-reference/sql-functions/other-functions/pg-get-indexdef"},{"title":"shobj_description()","sidebarTitle":"shobj_description","href":"/sql-reference/sql-functions/other-functions/shobj-description"},{"title":"pg_backend_pid()","sidebarTitle":"pg_backend_pid","href":"/sql-reference/sql-functions/other-functions/pg-backend-pid"},{"title":"pg_encoding_to_char()","sidebarTitle":"pg_encoding_to_char","href":"/sql-reference/sql-functions/other-functions/pg-encoding-to-char"},{"title":"pg_relation_is_publishable()","sidebarTitle":"pg_relation_is_publishable","href":"/sql-reference/sql-functions/other-functions/pg-relation-is-publishable"},{"title":"pg_get_userbyid()","sidebarTitle":"pg_get_userbyid","href":"/sql-reference/sql-functions/other-functions/pg-get-userbyid"},{"title":"pg_get_statisticsobjdef_columns()","sidebarTitle":"pg_get_statisticsobjdef_columns","href":"/sql-reference/sql-functions/other-functions/pg-get-statisticsobjdef-columns"}]},{"group":"Trigonometric","pages":[{"title":"Trigonometric Functions","href":"/sql-reference/sql-functions/trigonometric-functions/overview"}]}]},{"title":"Schema Definition","href":"/sql-reference/schema"},{"title":"Comment Support","href":"/sql-reference/comment-support"},{"title":"Transactions","href":"/sql-reference/transactions"}]},{"group":"Clients \u0026 Tools","pages":[{"group":"Language Clients","pages":[{"title":"C# (Dapper - Npgsql)","href":"/clients-tools/language-clients/dotnet-dapper"},{"title":"Java (JDBC)","href":"/clients-tools/language-clients/java-jdbc"},{"title":"PHP (PDO)","href":"/clients-tools/language-clients/php-pdo"},{"title":"Psycopg2","href":"/clients-tools/language-clients/psycopg2"}]}]},{"group":"Security","pages":[{"title":"Access Control","sidebarTitle":"Access Control","href":"/security/access-control"},{"title":"Roles","href":"/security/roles"},{"title":"Ownership","href":"/security/ownership"},{"title":"Privileges","href":"/security/privileges"},{"title":"Permission Rules for Operations","href":"/security/operation-permission-rules"},{"title":"SSL Configuration","href":"/security/ssl-configuration"}]},{"group":"System Catalogs","pages":[{"title":"Overview","href":"/system-catalogs/overview"},{"title":"Oxla Home Files","href":"/system-catalogs/oxla_home_files"},{"title":"Data Task Stability","href":"/system-catalogs/data_task_stability"},{"group":"Catalogs","pages":[{"title":"pg_description","href":"/system-catalogs/catalogs/pg_description"},{"title":"pg_settings","href":"/system-catalogs/catalogs/pg_settings"},{"title":"pg_index","href":"/system-catalogs/catalogs/pg_index"},{"title":"pg_namespace","href":"/system-catalogs/catalogs/pg_namespace"},{"title":"pg_attrdef","href":"/system-catalogs/catalogs/pg_attrdef"},{"title":"pg_depend","href":"/system-catalogs/catalogs/pg_depend"},{"title":"pg_constraint","href":"/system-catalogs/catalogs/pg_constraint"},{"title":"pg_statio_user_tables","href":"/system-catalogs/catalogs/pg_statio_user_tables"},{"title":"pg_type","href":"/system-catalogs/catalogs/pg_type"},{"title":"pg_attribute","href":"/system-catalogs/catalogs/pg_attribute"},{"title":"pg_class","href":"/system-catalogs/catalogs/pg_class"}]}]},{"group":"Troubleshooting \u0026 Optimization","pages":[{"title":"Error Handling","href":"/troubleshooting-optimization/error-handling"},{"title":"Degraded State Handling","href":"/troubleshooting-optimization/degraded-state-handling"}]}]},{"group":"Resources","pages":[{"title":"OLTP vs. OLAP","href":"/resources/oltp-vs-olap"},{"title":"Oxla vs. PostgreSQL","href":"/resources/oxla-vs-postgresql"}]}]},"basePath":"","title":"Time Operators - Oxla Developer Hub","deploymentId":"dpl_DyXGnKeCjZyA3sUdfMJ7FjkdBefg","buildId":"dpl_DyXGnKeCjZyA3sUdfMJ7FjkdBefg","dynamics":["10e4515597"],"chunks":["BannerMarkdown-BOAJk9BH.js","dist-Dl6_zDnT.js","lib-DMeTj1gb.js","lib-B8HbPgcC.js","katex-Dbtb6Wk7.js","html-void-elements-mCSPHezU.js","marked.esm-CZWythHk.js"]}