https://docs.holistics.io/assets/js/589f00ca.b5f0a2f5.js

1"use strict";(self.webpackChunkholistics_docs=self.webpackChunkholistics_docs||[]).push([["21286"],{74072(e,t,r){r.r(t),r.d(t,{metadata:()=>d,default:()=>h,frontMatter:()=>n,contentTitle:()=>a,toc:()=>l,assets:()=>c});var d=JSON.parse('{"id":"reference/aql/type-datetime","title":"Datetime","description":"AQL\'s datetime type stores timestamps as \\"YYYY-MM-DD HH:MM:SS\\", handles time zones automatically, and adds operators for filtering by exact times or periods.","source":"@site/docs/reference/aql/type-datetime.md","sourceDirName":"reference/aql","slug":"/reference/aql/type-datetime","permalink":"/reference/aql/type-datetime","draft":false,"unlisted":false,"tags":[],"version":"current","frontMatter":{"title":"Datetime","description":"AQL\'s datetime type stores timestamps as \\"YYYY-MM-DD HH:MM:SS\\", handles time zones automatically, and adds operators for filtering by exact times or periods."},"sidebar":"reference","previous":{"title":"Date","permalink":"/reference/aql/type-date"},"next":{"title":"Truefalse","permalink":"/reference/aql/type-truefalse"}}'),s=r(74848),i=r(28453);let n={title:"Datetime",description:'AQL\'s datetime type stores timestamps as "YYYY-MM-DD HH:MM:SS", handles time zones automatically, and adds operators for filtering by exact times or periods.'},a,c={},l=[{value:"Definition",id:"definition",level:2},{value:"Datetime Operator",id:"datetime-operator",level:2}];function o(e){let t={code:"code",h2:"h2",li:"li",p:"p",pre:"pre",ul:"ul",...(0,i.R)(),...e.components};return(0,s.jsxs)(s.Fragment,{children:[(0,s.jsx)(t.h2,{id:"definition",children:"Definition"}),"\n",(0,s.jsxs)(t.p,{children:['A datetime value, represented as a string in the format "YYYY-MM-DD HH:MM',":SS",'". The "datetime" type includes both date and time information, and is typically used to represent timestamps in the local time zone of the system or application where it is being used. It also has built-in time zone handling, which allows it to handle time zone conversions and daylight saving time adjustments automatically.']}),"\n",(0,s.jsx)(t.pre,{children:(0,s.jsx)(t.code,{className:"language-aml",children:'dimension order_shipped_at {\n  label: "Order Shipped At"\n  type: "datetime"\n}\n'})}),"\n",(0,s.jsx)(t.h2,{id:"datetime-operator",children:"Datetime Operator"}),"\n",(0,s.jsxs)("table",{children:[(0,s.jsx)("thead",{children:(0,s.jsxs)("tr",{children:[(0,s.jsx)("th",{children:"Operator"}),(0,s.jsx)("th",{children:"Example"}),(0,s.jsx)("th",{children:"Meaning"}),(0,s.jsx)("th",{children:"Description"})]})}),(0,s.jsxs)("tbody",{children:[(0,s.jsxs)("tr",{children:[(0,s.jsx)("td",{children:(0,s.jsx)("code",{children:"=="})}),(0,s.jsx)("td",{children:(0,s.jsxs)(t.ul,{children:["\n",(0,s.jsxs)(t.li,{children:["\n",(0,s.jsx)("code",{children:"orders.created_at == @2022 "}),"\n",(0,s.jsx)("br",{}),"\n"]}),"\n",(0,s.jsxs)(t.li,{children:["\n",(0,s.jsx)("code",{children:"orders.created_at == @(last 7 days)"}),"\n"]}),"\n"]})}),(0,s.jsxs)("td",{children:["- ",(0,s.jsx)("code",{children:"orders.created_at"})," equal to ",(0,s.jsx)("code",{children:"2022-01-01 00:00:00"}),(0,s.jsx)("br",{}),"- ",(0,s.jsx)("code",{children:"orders_created_at"})," equal to the first timestamp of the last 7 days"]}),(0,s.jsx)("td",{children:"Include data that equal to an absolute timestamp"})]}),(0,s.jsxs)("tr",{children:[(0,s.jsxs)("td",{children:[(0,s.jsx)("code",{children:"is"}),(0,s.jsx)("br",{}),(0,s.jsx)("code",{children:"matches"}),(0,s.jsx)("br",{}),(0,s.jsx)("code",{children:"match"})]}),(0,s.jsx)("td",{children:(0,s.jsxs)(t.ul,{children:["\n",(0,s.jsxs)(t.li,{children:["\n",(0,s.jsx)("code",{children:"orders.created_at is @2022 "}),"\n",(0,s.jsx)("br",{}),"\n"]}),"\n",(0,s.jsxs)(t.li,{children:["\n",(0,s.jsx)("code",{children:" orders.created_at match @(last 7 days)"}),"\n"]}),"\n"]})}),(0,s.jsxs)("td",{children:["- ",(0,s.jsx)("code",{children:"orders.created_at"}

1)," is in the period of the year ",(0,s.jsx)("code",{children:"2022"}),(0,s.jsx)("br",{}),"- ",(0,s.jsx)("code",{children:"order.created_at"})," is in the period of the last 7 days"]}),(0,s.jsx)("td",{children:"Include data that are in a time period"})]}),(0,s.jsxs)("tr",{children:[(0,s.jsx)("td",{children:(0,s.jsx)("code",{children:"!="})}),(0,s.jsx)("td",{children:(0,s.jsx)("code",{children:"orders.created_at != @2022-01"})}),(0,s.jsxs)("td",{children:["- ",(0,s.jsx)("code",{children:"orders.created_at"})," is not equal to ",(0,s.jsx)("code",{children:"2022-01-01 00:00:00"})]}),(0,s.jsx)("td",{children:"Include data that do not equal to an absolute timestamp"})]}),(0,s.jsxs)("tr",{children:[(0,s.jsx)("td",{children:(0,s.jsx)("code",{children:"is not"})}),(0,s.jsx)("td",{children:(0,s.jsx)("code",{children:"orders.created_at is not @2022-01"})}),(0,s.jsxs)("td",{children:["- ",(0,s.jsx)("code",{children:"orders.created_at"})," is not in the period of ",(0,s.jsx)("code",{children:"2022-01"})]}),(0,s.jsx)("td",{children:"Include data that are not in a time period"})]}),(0,s.jsxs)("tr",{children:[(0,s.jsx)("td",{children:(0,s.jsx)("code",{children:">"})}),(0,s.jsx)("td",{children:(0,s.jsx)("code",{children:"orders.created_at > @(yesterday)"})}),(0,s.jsxs)("td",{children:["- ",(0,s.jsx)("code",{children:"orders.created_at"})," is after yesterday"]}),(0,s.jsx)("td",{children:"Include data that are after a specific time period"})]}),(0,s.jsxs)("tr",{children:[(0,s.jsx)("td",{children:(0,s.jsx)("code",{children:"<"})}),(0,s.jsx)("td",{children:(0,s.jsx)("code",{children:"orders.created_at < @2022"})}),(0,s.jsxs)("td",{children:["- ",(0,s.jsx)("code",{children:"orders.created_at"})," is before the year 2022"]}),(0,s.jsx)("td",{children:"Include data that are before a specific time period"})]})]})]})]})}function h(e={}){let{wrapper:t}={...(0,i.R)(),...e.components};return t?(0,s.jsx)(t,{...e,children:(0,s.jsx)(o,{...e})}):o(e)}},28453(e,t,r){r.d(t,{R:()=>n,x:()=>a});var d=r(96540);let s={},i=d.createContext(s);function n(e){let t=d.useContext(i);return d.useMemo(function(){return"function"==typeof e?e(t):{...t,...e}},[t,e])}function a(e){let t;return t=e.disableParentContext?"function"==typeof e.components?e.components(s):e.components||s:n(e.components),d.createElement(i.Provider,{value:t},e.children)}}}]);