Round down the datetime expression to the specified unit. If an offset is specified, then the datetime will be rounded down to the nearest unit after the offset.If multiple units are specified, these will be combined together to form the unit. E.g. 1 quarter and 1 month will be transformed to 4 months.
Parameters
int | IntegerValue | None
int | IntegerValue | None
int | IntegerValue | None
int | IntegerValue | None
int | IntegerValue | None
int | IntegerValue | None
int | IntegerValue | None
int | IntegerValue | None
int | IntegerValue | None
IntervalValue | None
Was this page helpful?
{"docsConfig":{"$schema":"https://mintlify.com/docs.json","theme":"mint","name":"turntable","colors":{"primary":"#ff996d","light":"#ff996d","dark":"#ff996d"},"favicon":"/favicon.png","logo":{"light":"https://mintcdn.com/turntable/R01qYC8M1Qe_GhCg/logo_light.png?fit=max\u0026auto=format\u0026n=R01qYC8M1Qe_GhCg\u0026q=85\u0026s=cb06ad2dabda5538ca5e0c7934f06448","dark":"https://mintcdn.com/turntable/R01qYC8M1Qe_GhCg/logo_dark.png?fit=max\u0026auto=format\u0026n=R01qYC8M1Qe_GhCg\u0026q=85\u0026s=d5b369063e4b595b13529633741a060f"},"navbar":{"primary":{"type":"button","label":"Get Started","href":"https://www.turntable.so/get-started"}},"footer":{"socials":{"twitter":"https://twitter.com/Turntable","github":"https://github.com/turntable-so","linkedin":"https://www.linkedin.com/company/92694701/"}},"navigation":{"global":{"anchors":[{"anchor":"Join our Slack","href":"https://join.slack.com/t/turntable-community/shared_invite/zt-25p0olvhz-Z~c5QWq1jv2YFHQ46mMFDA","icon":"slack"},{"anchor":"GitHub","href":"https://github.com/turntable-so/vinyl","icon":"github"}]},"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"turntable","hasAudioNarration":false,"actualSubdomain":"turntable","customDomains":["docs.turntable.so"],"gitSource":{"type":"github","owner":"ianrtracey","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":false,"mountPath":"","label":""},"feedback":{"thumbs":true},"entitlements":{},"buildId":"6ae91ef1dd662a242ab81001:success","clientVersion":"0.0.4143","searchFilterCounts":[{"language":"default","tag":"Reference","count":23},{"language":"default","tag":"CLI","count":11},{"language":"default","tag":"Extension","count":9},{"language":"default","tag":"Column Reference","count":9},{"language":"default","tag":"Basic Concepts","count":5},{"language":"default","tag":"Getting started","count":3},{"language":"default","tag":"Connectors","count":3},{"language":"default","tag":"FAQ","count":2},{"language":"default","tag":"Column-level lineage","count":2},{"language":"default","tag":"Docs composer","count":2}]},"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":"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":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"reference/column/dt","slug":"/reference/column/dt","pageMetadata":{"title":"Datetime Operations","description":null,"href":"/reference/column/dt"},"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={p:`p`,..._provideComponents(),...props.components},{Accordion,Heading,ParamField}=_components;if(!Accordion)_missingMdxReference(`Accordion`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!ParamField)_missingMdxReference(`ParamField`,true);return _jsxs(_Fragment,{children:[_jsx(Heading,{level:`2`,id:`dt-extract`,children:`dt.extract`}),`\n`,_jsx(_components.p,{children:`Extract the specified component from the datetime expression.`}),`\n`,_jsx(Accordion,{title:`Parameters`,id:`parameters`,children:_jsx(ParamField,{body:`unit`,type:`Literal['year', 'quarter', 'month', 'week_of_year', 'day', 'day_of_year', 'hour', 'minute', 'second', 'microsecond', 'millisecond']`,required:true,id:`param-unit`})}),`\n`,_jsx(Heading,{level:`2`,id:`dt-floor`,children:`dt.floor`}),`\n`,_jsx(_components.p,{children:`Round down the datetime expression to the specified unit. If an offset is specified, then the datetime will be rounded down to the nearest unit after the offset.`}),`\n`,_jsx(_components.p,{children:`If multiple units are specified, these will be combined together to form the unit. E.g. 1 quarter and 1 month will be transformed to 4 months.`}),`\n`,_jsxs(Accordion,{title:`Parameters`,id:`parameters-1`,children:[_jsx(ParamField,{body:`years`,type:`int | IntegerValue | None`,required:false,id:`param-years`}),_jsx(ParamField,{body:`quarters`,type:`int | IntegerValue | None`,required:false,id:`param-quarters`}),_jsx(ParamField,{body:`months`,type:`int | IntegerValue | None`,required:false,id:`param-months`}),_jsx(ParamField,{body:`weeks`,type:`int | IntegerValue | None`,required:false,id:`param-weeks`}),_jsx(ParamField,{body:`days`,type:`int | IntegerValue | None`,required:false,id:`param-days`}),_jsx(ParamField,{body:`hours`,type:`int | IntegerValue | None`,required:false,id:`param-hours`}),_jsx(ParamField,{body:`minutes`,type:`int | IntegerValue | None`,required:false,id:`param-minutes`}),_jsx(ParamField,{body:`seconds`,type:`int | IntegerValue | None`,required:false,id:`param-seconds`}),_jsx(ParamField,{body:`milliseconds`,type:`int | IntegerValue | None`,required:false,id:`param-milliseconds`}),_jsx(ParamField,{body:`offset`,type:`IntervalValue | None`,required:false,id:`param-offset`})]})]})}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":"Datetime Operations","description":null,"href":"/reference/column/dt"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"dt.extract","slug":"dt-extract","depth":2,"children":[]},{"title":"dt.floor","slug":"dt-floor","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"turntable","siteName":"turntable","title":"Datetime Operations - turntable","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-01-07T00:52:01.774Z","originalFileLocation":"reference/column/dt.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=\"turntable\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/turntable/Dj3WJb4nh77Ftel1/_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/turntable/Dj3WJb4nh77Ftel1/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/turntable/Dj3WJb4nh77Ftel1/_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/turntable/Dj3WJb4nh77Ftel1/_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/turntable/Dj3WJb4nh77Ftel1/_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/turntable/Dj3WJb4nh77Ftel1/_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/turntable/Dj3WJb4nh77Ftel1/_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/turntable/Dj3WJb4nh77Ftel1/_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/turntable/Dj3WJb4nh77Ftel1/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Datetime Operations - turntable\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"turntable\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.turntable.so/reference/column/dt\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://turntable.mintlify.site/_mintlify/api/og/v2?division=Column+Reference\u0026amp;title=Datetime+Operations\u0026amp;theme=4436d9fd61f818e90d58c0cb\u0026amp;signature=b6d1ab08fac982e8f5db18d275d477facfbf3de64777dc60d1920bd0d291b2af\">\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=\"Datetime Operations - turntable\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://turntable.mintlify.site/_mintlify/api/og/v2?division=Column+Reference\u0026amp;title=Datetime+Operations\u0026amp;theme=4436d9fd61f818e90d58c0cb\u0026amp;signature=b6d1ab08fac982e8f5db18d275d477facfbf3de64777dc60d1920bd0d291b2af\">\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/turntable/Dj3WJb4nh77Ftel1/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"turntable\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#ff996d\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.turntable.so/reference/column/dt\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/reference/column/dt.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.turntable.so/#organization\",\"name\":\"turntable\",\"url\":\"https://docs.turntable.so\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/turntable/R01qYC8M1Qe_GhCg/logo_light.png?fit=max\u0026auto=format\u0026n=R01qYC8M1Qe_GhCg\u0026q=85\u0026s=cb06ad2dabda5538ca5e0c7934f06448\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.turntable.so#website\",\"name\":\"turntable\",\"url\":\"https://docs.turntable.so\",\"publisher\":{\"@id\":\"https://docs.turntable.so/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.turntable.so/reference/column/dt#webpage\",\"url\":\"https://docs.turntable.so/reference/column/dt\",\"name\":\"Datetime Operations\",\"dateModified\":\"2026-01-07T00:52:01.774Z\",\"isPartOf\":{\"@id\":\"https://docs.turntable.so#website\"},\"breadcrumb\":{\"@id\":\"https://docs.turntable.so/reference/column/dt#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.turntable.so/reference/column/dt#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Reference\",\"item\":\"https://docs.turntable.so/reference/table\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Column Reference\",\"item\":\"https://docs.turntable.so/reference/column/standard\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Datetime Operations\",\"item\":\"https://docs.turntable.so/reference/column/dt\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.turntable.so/reference/column/dt#article\",\"headline\":\"Datetime Operations\",\"name\":\"Datetime Operations\",\"url\":\"https://docs.turntable.so/reference/column/dt\",\"mainEntityOfPage\":{\"@id\":\"https://docs.turntable.so/reference/column/dt#webpage\"},\"dateModified\":\"2026-01-07T00:52:01.774Z\",\"publisher\":{\"@id\":\"https://docs.turntable.so/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.turntable.so#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"turntable\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"turntable\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/reference/column/dt.md","siteName":"turntable","nav":{"global":{"anchors":[{"anchor":"Join our Slack","href":"https://join.slack.com/t/turntable-community/shared_invite/zt-25p0olvhz-Z~c5QWq1jv2YFHQ46mMFDA","icon":"slack"},{"anchor":"GitHub","href":"https://github.com/turntable-so/vinyl","icon":"github"}]},"tabs":[{"tab":"Documentation","pages":[{"title":"Documentation","href":"/security/on_prem_agent"}]},{"tab":"Extension","pages":[{"title":"Extension","href":"/extension/getting-started/prerequisites"}]},{"tab":"CLI","pages":[{"title":"CLI","href":"/vinyl/introduction"}]},{"tab":"Reference","groups":[{"group":"Connectors","pages":[{"title":"Postgres","href":"/reference/connectors/postgres"},{"title":"BigQuery","href":"/reference/connectors/big_query"},{"title":"File","href":"/reference/connectors/file"}]},{"group":"Reference","pages":[{"group":"Table Reference","pages":[{"title":"Table Operations","href":"/reference/table"}]},{"group":"Column Reference","pages":[{"title":"Standard Operations","href":"/reference/column/standard"},{"title":"Math Operations","href":"/reference/column/math"},{"title":"Regex Operations","href":"/reference/column/re"},{"title":"String Operations","href":"/reference/column/str"},{"title":"Struct Operations","description":null,"href":"/reference/column/obj"},{"title":"Datetime Operations","href":"/reference/column/dt"},{"title":"Map Operations","description":null,"href":"/reference/column/dict"},{"title":"URL Operations","href":"/reference/column/url"},{"title":"Array Operations","href":"/reference/column/array"}]}]}]}]},"basePath":"","title":"Datetime Operations - turntable","buildId":"dpl_Fyv1NbzwP68g2bEH2Roy98uY1zmE","deploymentId":"dpl_Fyv1NbzwP68g2bEH2Roy98uY1zmE","dynamics":[],"chunks":[]}