| <!DOCTYPE html> |
| |
| |
| |
| <html lang="en"> |
| <head> |
| <!-- Global site tag (gtag.js) - Google Analytics --> |
| <script async src="https://www.googletagmanager.com/gtag/js?id=UA-61232409-1"></script> |
| <script> |
| window.dataLayer = window.dataLayer || []; |
| function gtag(){dataLayer.push(arguments);} |
| gtag('js', new Date()); |
| |
| gtag('config', 'UA-61232409-1'); |
| </script> |
| |
| |
| |
| <meta charset="UTF-8"> |
| <meta name="ignite-version" content="2.9.0" /> |
| <title>Date and Time Functions | Ignite Documentation</title> |
| |
| <link rel="canonical" href="/docs/2.9.0/sql-reference/date-time-functions" /> |
| |
| |
| <link rel="stylesheet" href="/assets/css/styles.css?1598500267"> |
| <link rel="stylesheet" href="/assets/css/asciidoc-pygments.css"> |
| <link rel="shortcut icon" href="/favicon.ico"> |
| <meta name='viewport' content='width=device-width, height=device-height, initial-scale=1.0, minimum-scale=1.0'> |
| |
| <script type="text/javascript" src="/assets/js/anchor.min.js?1598500267"></script> |
| <link |
| rel="stylesheet" |
| href="https://cdn.jsdelivr.net/npm/docsearch.js@2/dist/cdn/docsearch.min.css" |
| /> |
| |
| </head> |
| <body> |
| <header> |
| <div class="container"> |
| <button type='button' class='menu' title='Docs menu'> |
| <img src="/assets/images/menu-icon.svg"/> |
| </button> |
| <div class='home'> |
| <a href="/" class='home' title='Apache Ignite home'> |
| <img src="/assets/images/apache_ignite_logo.svg" alt="Apache Ignite logo" width="103" > |
| </a> |
| </div> |
| |
| <nav> |
| |
| </nav> |
| |
| <select id="version-selector"> |
| <option value="2.9.0">2.9.0</option> |
| </select> |
| |
| <a href="https://github.com/ignite" title='GitHub' class='github' target="_blank"> |
| <img src="/assets/images/github-gray.svg" alt="GitHub logo"> |
| </a> |
| |
| <form class='search'> |
| <button class="search-close" type='button'><img src='/assets/images/cancel.svg'></button> |
| <input type="search" placeholder="Search…" id="search-input"> |
| </form> |
| <button type='button' class='search-toggle'><img src='/assets/images/search.svg'></button> |
| <button type='button' class='top-nav-toggle'>⋮</button> |
| |
| |
| |
| </div> |
| </header> |
| |
| |
| <link rel="stylesheet" href="/assets/css/docs.css"> |
| <section class='page-docs'> |
| |
| |
| |
| |
| <nav class='left-nav' data-swiftype-index='false'> |
| |
| |
| <li> |
| |
| |
| <a href="/docs/2.9.0//preface" class='' >Preface</a> |
| |
| </li> |
| |
| <li> |
| |
| |
| |
| |
| |
| |
| <button type='button' data-guide-url="" class='group-toggle collapsed '>Quick Start Guides<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class='nav-group collapsed'> |
| |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//quick-start/java" |
| |
| class='' |
| >Java</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//quick-start/dotnet" |
| |
| class='' |
| >.NET/C#</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//quick-start/cpp" |
| |
| class='' |
| >C++</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//quick-start/python" |
| |
| class='' |
| >Python</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//quick-start/nodejs" |
| |
| class='' |
| >Node.JS</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//quick-start/sql" |
| |
| class='' |
| >SQL</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//quick-start/php" |
| |
| class='' |
| >PHP</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//quick-start/restapi" |
| |
| class='' |
| >REST API</a> |
| |
| </li> |
| |
| |
| |
| </nav> |
| |
| </li> |
| |
| <li> |
| |
| |
| |
| |
| |
| |
| <button type='button' data-guide-url="/installation" class='group-toggle collapsed '>Installation<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class='nav-group collapsed'> |
| |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//installation/installing-using-zip" |
| |
| class='' |
| >Installing Using ZIP Archive</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//installation/installing-using-docker" |
| |
| class='' |
| >Installing Using Docker</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//installation/deb-rpm" |
| |
| class='' |
| >Installing DEB or RPM package</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| |
| |
| <button |
| type='button' |
| class='collapsed '>Kubernetes<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class="sub_pages collapsed"> |
| |
| |
| |
| |
| <li><a href="/docs/2.9.0//installation/kubernetes/amazon-eks-deployment" class=''>Amazon EKS</a></li> |
| |
| |
| |
| <li><a href="/docs/2.9.0//installation/kubernetes/azure-deployment" class=''>Azure Kubernetes Service</a></li> |
| |
| |
| |
| <li><a href="/docs/2.9.0//installation/kubernetes/gke-deployment" class=''>Google Kubernetes Engine</a></li> |
| |
| </nav> |
| |
| </li> |
| |
| |
| |
| </nav> |
| |
| </li> |
| |
| <li> |
| |
| |
| |
| |
| |
| |
| <button type='button' data-guide-url="" class='group-toggle collapsed '>Setting Up<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class='nav-group collapsed'> |
| |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//setup" |
| |
| class='' |
| >Setting Up Ignite for Java</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//setup-dotnet" |
| |
| class='' |
| >Setting Up Ignite for .NET/C#</a> |
| |
| </li> |
| |
| |
| |
| </nav> |
| |
| </li> |
| |
| <li> |
| |
| |
| <a href="/docs/2.9.0//understanding-configuration" class='' >Understanding Configuration</a> |
| |
| </li> |
| |
| <li> |
| |
| |
| <a href="/docs/2.9.0//logging" class='' >Configuring Logging</a> |
| |
| </li> |
| |
| <li> |
| |
| |
| <a href="/docs/2.9.0//starting-nodes" class='' >Starting and Stopping Nodes</a> |
| |
| </li> |
| |
| <li> |
| |
| |
| |
| |
| |
| |
| <button type='button' data-guide-url="" class='group-toggle collapsed '>Clustering<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class='nav-group collapsed'> |
| |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//clustering/clustering" |
| |
| class='' |
| >Overview</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//clustering/tcp-ip-discovery" |
| |
| class='' |
| >TCP/IP Discovery</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//clustering/zookeeper-discovery" |
| |
| class='' |
| >ZooKeeper Discovery</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//clustering/discovery-in-the-cloud" |
| |
| class='' |
| >Discovery in the Cloud</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//clustering/network-configuration" |
| |
| class='' |
| >Network Configuration</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//clustering/connect-client-nodes" |
| |
| class='' |
| >Connecting Client Nodes</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//clustering/running-client-nodes-behind-nat" |
| |
| class='' |
| >Running Client Nodes Behind NAT</a> |
| |
| </li> |
| |
| |
| |
| </nav> |
| |
| </li> |
| |
| <li> |
| |
| |
| |
| |
| |
| |
| <button type='button' data-guide-url="" class='group-toggle collapsed '>Data Modeling<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class='nav-group collapsed'> |
| |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//data-modeling/data-modeling" |
| |
| class='' |
| >Introduction</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//data-modeling/data-partitioning" |
| |
| class='' |
| >Data Partitioning</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//data-modeling/affinity-collocation" |
| |
| class='' |
| >Affinity Colocation</a> |
| |
| </li> |
| |
| |
| |
| </nav> |
| |
| </li> |
| |
| <li> |
| |
| |
| |
| |
| |
| |
| <button type='button' data-guide-url="" class='group-toggle collapsed '>Configuring Memory<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class='nav-group collapsed'> |
| |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//memory-architecture" |
| |
| class='' |
| >Memory Architecture</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//memory-configuration/data-regions" |
| |
| class='' |
| >Configuring Data Regions</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//memory-configuration/eviction-policies" |
| |
| class='' |
| >Eviction Policies</a> |
| |
| </li> |
| |
| |
| |
| </nav> |
| |
| </li> |
| |
| <li> |
| |
| |
| |
| |
| |
| |
| <button type='button' data-guide-url="" class='group-toggle collapsed '>Configuring Caches<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class='nav-group collapsed'> |
| |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//configuring-caches/configuration-overview" |
| |
| class='' |
| >Cache Configuration</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//configuring-caches/configuring-backups" |
| |
| class='' |
| >Configuring Partition Backups</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//configuring-caches/atomicity-modes" |
| |
| class='' |
| >Atomicity Modes</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//configuring-caches/expiry-policies" |
| |
| class='' |
| >Expiry Policy</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//configuring-caches/on-heap-caching" |
| |
| class='' |
| >On-Heap Caching</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//configuring-caches/cache-groups" |
| |
| class='' |
| >Cache Groups</a> |
| |
| </li> |
| |
| |
| |
| </nav> |
| |
| </li> |
| |
| <li> |
| |
| |
| |
| |
| |
| |
| <button type='button' data-guide-url="" class='group-toggle collapsed '>Persistence<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class='nav-group collapsed'> |
| |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//persistence/native-persistence" |
| |
| class='' |
| >Ignite Persistence</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//persistence/external-storage" |
| |
| class='' |
| >External Storage</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//persistence/swap" |
| |
| class='' |
| >Swapping</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//persistence/custom-cache-store" |
| |
| class='' |
| >Implementing Custom Cache Store</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//persistence/disk-compression" |
| |
| class='' |
| >Disk Compression</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//persistence/persistence-tuning" |
| |
| class='' |
| >Tuning Persistence</a> |
| |
| </li> |
| |
| |
| |
| </nav> |
| |
| </li> |
| |
| <li> |
| |
| |
| <a href="/docs/2.9.0//baseline-topology" class='' >Baseline Topology</a> |
| |
| </li> |
| |
| <li> |
| |
| |
| <a href="/docs/2.9.0//cluster-states" class='' >Cluster States</a> |
| |
| </li> |
| |
| <li> |
| |
| |
| <a href="/docs/2.9.0//data-rebalancing" class='' >Data Rebalancing</a> |
| |
| </li> |
| |
| <li> |
| |
| |
| <a href="/docs/2.9.0//partition-loss-policy" class='' >Partition Loss Policy</a> |
| |
| </li> |
| |
| <li> |
| |
| |
| <a href="/docs/2.9.0//peer-class-loading" class='' >Peer Class Loading</a> |
| |
| </li> |
| |
| <li> |
| |
| |
| <a href="/docs/2.9.0//data-streaming" class='' >Data Streaming</a> |
| |
| </li> |
| |
| <li> |
| |
| |
| |
| |
| |
| |
| <button type='button' data-guide-url="" class='group-toggle collapsed '>Using Key-Value Cache API<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class='nav-group collapsed'> |
| |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//key-value-api/basic-cache-operations" |
| |
| class='' |
| >Basic Cache Operations</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//key-value-api/binary-objects" |
| |
| class='' |
| >Working with Binary Objects</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//key-value-api/using-scan-queries" |
| |
| class='' |
| >Using Scan Queries</a> |
| |
| </li> |
| |
| |
| |
| </nav> |
| |
| </li> |
| |
| <li> |
| |
| |
| <a href="/docs/2.9.0//key-value-api/continuous-queries" class='' >Using Continuous Queries</a> |
| |
| </li> |
| |
| <li> |
| |
| |
| <a href="/docs/2.9.0//key-value-api/transactions" class='' >Performing Transactions</a> |
| |
| </li> |
| |
| <li> |
| |
| |
| |
| |
| |
| |
| <button type='button' data-guide-url="" class='group-toggle collapsed '>Working with SQL<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class='nav-group collapsed'> |
| |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//SQL/sql-introduction" |
| |
| class='' |
| >Introduction</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//SQL/schemas" |
| |
| class='' |
| >Understanding Schemas</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//SQL/indexes" |
| |
| class='' |
| >Defining Indexes</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//SQL/sql-api" |
| |
| class='' |
| >Using SQL API</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//SQL/distributed-joins" |
| |
| class='' |
| >Distributed Joins</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//SQL/sql-transactions" |
| |
| class='' |
| >SQL Transactions</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//SQL/custom-sql-func" |
| |
| class='' |
| >Custom SQL Functions</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//SQL/JDBC/jdbc-driver" |
| |
| class='' |
| >JDBC Driver</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//SQL/JDBC/jdbc-client-driver" |
| |
| class='' |
| >JDBC Client Driver</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//transactions/mvcc" |
| |
| class='' |
| >Multiversion Concurrency Control</a> |
| |
| </li> |
| |
| |
| |
| </nav> |
| |
| </li> |
| |
| <li> |
| |
| |
| |
| |
| |
| |
| <button type='button' data-guide-url="" class='group-toggle collapsed '>Distributed Computing<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class='nav-group collapsed'> |
| |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//distributed-computing/distributed-computing" |
| |
| class='' |
| >Distributed Computing API</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//distributed-computing/cluster-groups" |
| |
| class='' |
| >Cluster Groups</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//distributed-computing/executor-service" |
| |
| class='' |
| >Executor Service</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//distributed-computing/map-reduce" |
| |
| class='' |
| >MapReduce API</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//distributed-computing/load-balancing" |
| |
| class='' |
| >Load Balancing</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//distributed-computing/fault-tolerance" |
| |
| class='' |
| >Fault Tolerance</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//distributed-computing/job-scheduling" |
| |
| class='' |
| >Job Scheduling</a> |
| |
| </li> |
| |
| |
| |
| </nav> |
| |
| </li> |
| |
| <li> |
| |
| |
| <a href="/docs/2.9.0//collocated-computations" class='' >Colocating Computations with Data</a> |
| |
| </li> |
| |
| <li> |
| |
| |
| |
| |
| |
| |
| <button type='button' data-guide-url="" class='group-toggle collapsed '>Working with Events<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class='nav-group collapsed'> |
| |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//events/listening-to-events" |
| |
| class='' |
| >Enabling and Listenting to Events</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//events/events" |
| |
| class='' |
| >Events</a> |
| |
| </li> |
| |
| |
| |
| </nav> |
| |
| </li> |
| |
| <li> |
| |
| |
| <a href="/docs/2.9.0//near-cache" class='' >Near Caches</a> |
| |
| </li> |
| |
| <li> |
| |
| |
| |
| |
| |
| |
| <button type='button' data-guide-url="" class='group-toggle collapsed '>Monitoring<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class='nav-group collapsed'> |
| |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//monitoring-metrics/intro" |
| |
| class='' |
| >Introduction</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//monitoring-metrics/cluster-id" |
| |
| class='' |
| >Cluster ID and Tag</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| |
| |
| <button |
| type='button' |
| class='collapsed '>Metrics<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class="sub_pages collapsed"> |
| |
| |
| |
| |
| <li><a href="/docs/2.9.0//monitoring-metrics/configuring-metrics" class=''>Configuring Metrics</a></li> |
| |
| |
| |
| <li><a href="/docs/2.9.0//monitoring-metrics/metrics" class=''>JMX Metrics</a></li> |
| |
| </nav> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| |
| |
| <button |
| type='button' |
| class='collapsed '>New Metrics System<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class="sub_pages collapsed"> |
| |
| |
| |
| |
| <li><a href="/docs/2.9.0//monitoring-metrics/new-metrics-system" class=''>Introduction</a></li> |
| |
| |
| |
| <li><a href="/docs/2.9.0//monitoring-metrics/new-metrics" class=''>Metrics</a></li> |
| |
| </nav> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//monitoring-metrics/system-views" |
| |
| class='' |
| >System Views</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//monitoring-metrics/tracing" |
| |
| class='' |
| >Tracing</a> |
| |
| </li> |
| |
| |
| |
| </nav> |
| |
| </li> |
| |
| <li> |
| |
| |
| |
| |
| |
| |
| <button type='button' data-guide-url="/security" class='group-toggle collapsed '>Security<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class='nav-group collapsed'> |
| |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//security/authentication" |
| |
| class='' |
| >Authentication</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//security/ssl-tls" |
| |
| class='' |
| >SSL/TLS</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| |
| |
| <button |
| type='button' |
| class='collapsed '>Transparent Data Encryption<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class="sub_pages collapsed"> |
| |
| |
| |
| |
| <li><a href="/docs/2.9.0//security/tde" class=''>Introduction</a></li> |
| |
| |
| |
| <li><a href="/docs/2.9.0//security/master-key-rotation" class=''>Master key rotation</a></li> |
| |
| </nav> |
| |
| </li> |
| |
| |
| |
| </nav> |
| |
| </li> |
| |
| <li> |
| |
| |
| |
| |
| |
| |
| <button type='button' data-guide-url="" class='group-toggle collapsed '>Thin Clients<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class='nav-group collapsed'> |
| |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//thin-clients/getting-started-with-thin-clients" |
| |
| class='' |
| >Thin Clients Overview</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//thin-clients/java-thin-client" |
| |
| class='' |
| >Java Thin Client</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//thin-clients/dotnet-thin-client" |
| |
| class='' |
| >.NET Thin Client</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//thin-clients/cpp-thin-client" |
| |
| class='' |
| >C++ Thin Client</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//thin-clients/python-thin-client" |
| |
| class='' |
| >Python Thin Client</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//thin-clients/php-thin-client" |
| |
| class='' |
| >PHP Thin Client</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//thin-clients/nodejs-thin-client" |
| |
| class='' |
| >Node.js Thin Client</a> |
| |
| </li> |
| |
| |
| |
| </nav> |
| |
| </li> |
| |
| <li> |
| |
| |
| |
| |
| |
| |
| <button type='button' data-guide-url="" class='group-toggle collapsed '>ODBC Driver<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class='nav-group collapsed'> |
| |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//SQL/ODBC/odbc-driver" |
| |
| class='' |
| >ODBC Driver</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//SQL/ODBC/connection-string-dsn" |
| |
| class='' |
| >Connection String and DSN</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//SQL/ODBC/querying-modifying-data" |
| |
| class='' |
| >Querying and Modifying Data</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//SQL/ODBC/specification" |
| |
| class='' |
| >Specification</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//SQL/ODBC/data-types" |
| |
| class='' |
| >Data Types</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//SQL/ODBC/error-codes" |
| |
| class='' |
| >Error Codes</a> |
| |
| </li> |
| |
| |
| |
| </nav> |
| |
| </li> |
| |
| <li> |
| |
| |
| <a href="/docs/2.9.0//restapi" class='' >REST API</a> |
| |
| </li> |
| |
| <li> |
| |
| |
| <a href="/docs/2.9.0//control-script" class='' >Control Script</a> |
| |
| </li> |
| |
| <li> |
| |
| |
| <a href="/docs/2.9.0//plugins" class='' >Plugins</a> |
| |
| </li> |
| |
| <li> |
| |
| |
| <a href="/docs/2.9.0//sqlline" class='' >SQLLine</a> |
| |
| </li> |
| |
| <li> |
| |
| |
| |
| |
| |
| |
| <button type='button' data-guide-url="/sql-reference/sql-reference-overview" class='group-toggle collapsed '>SQL Reference<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button> |
| <nav class='nav-group collapsed'> |
| |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//sql-reference/ddl" |
| |
| class='' |
| >Data Definition Language (DDL)</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//sql-reference/dml" |
| |
| class='' |
| >Data Manipulation Language (DML)</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//sql-reference/transactions" |
| |
| class='' |
| >Transactions</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//sql-reference/operational-commands" |
| |
| class='' |
| >Operational Commands</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//sql-reference/aggregate-functions" |
| |
| class='' |
| >Aggregate functions</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//sql-reference/numeric-functions" |
| |
| class='' |
| >Numeric Functions</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//sql-reference/string-functions" |
| |
| class='' |
| >String Functions</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//sql-reference/date-time-functions" |
| |
| class='' |
| >Data and Time Functions</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//sql-reference/system-functions" |
| |
| class='' |
| >System Functions</a> |
| |
| </li> |
| |
| |
| |
| |
| |
| <li> |
| |
| <a href="/docs/2.9.0//sql-reference/data-types" |
| |
| class='' |
| >Data Types</a> |
| |
| </li> |
| |
| |
| |
| </nav> |
| |
| </li> |
| |
| </nav> |
| <div class="left-nav__overlay"></div> |
| |
| |
| <article data-swiftype-index='true'> |
| |
| <h1>Date and Time Functions</h1> |
| |
| <div class="sect1"> |
| <h2 id="current_date">CURRENT_DATE</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="err">{</span><span class="k">CURRENT_DATE</span> <span class="p">[()]</span> <span class="o">|</span> <span class="n">CURDATE</span><span class="p">()</span> <span class="o">|</span> <span class="n">SYSDATE</span> <span class="o">|</span> <span class="n">TODAY</span><span class="err">}</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Returns the current date. |
| When called multiple times within a transaction, this function returns the same value.</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="k">CURRENT_DATE</span><span class="p">()</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="current_time">CURRENT_TIME</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="err">{</span><span class="k">CURRENT_TIME</span> <span class="p">[</span> <span class="p">()</span> <span class="p">]</span> <span class="o">|</span> <span class="n">CURTIME</span><span class="p">()</span><span class="err">}</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Returns the current time. |
| When called multiple times within a transaction, this function returns the same value.</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="k">CURRENT_TIME</span><span class="p">()</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="current_timestamp">CURRENT_TIMESTAMP</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="err">{</span><span class="k">CURRENT_TIMESTAMP</span> <span class="p">[([</span><span class="nb">int</span><span class="p">])]</span> <span class="o">|</span> <span class="n">NOW</span><span class="p">([</span><span class="nb">int</span><span class="p">])</span><span class="err">}</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Returns the current timestamp. The precision parameter for nanoseconds precision is optional. This method always returns the same value within a transaction.</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="k">CURRENT_TIMESTAMP</span><span class="p">()</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="dateadd">DATEADD</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="err">{</span><span class="n">DATEADD</span><span class="o">|</span> <span class="n">TIMESTAMPADD</span><span class="err">}</span> <span class="p">(</span><span class="n">unitString</span><span class="p">,</span> <span class="n">addIntLong</span><span class="p">,</span> <span class="nb">timestamp</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Adds units to a timestamp. The string indicates the unit. Use negative values to subtract units. <code>addIntLong</code> may be a long value when manipulating milliseconds, otherwise its range is restricted to <code>int</code>. The same units as in the EXTRACT function are supported. The DATEADD method returns a timestamp. The TIMESTAMPADD method returns a long.</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">DATEADD</span><span class="p">(</span><span class="s1">'MONTH'</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="nb">DATE</span> <span class="s1">'2001-01-31'</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="datediff">DATEDIFF</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="err">{</span><span class="n">DATEDIFF</span> <span class="o">|</span> <span class="n">TIMESTAMPDIFF</span><span class="err">}</span> <span class="p">(</span><span class="n">unitString</span><span class="p">,</span> <span class="n">aTimestamp</span><span class="p">,</span> <span class="n">bTimestamp</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Returns the number of crossed unit boundaries between two timestamps. This method returns a <code>long</code>. The string indicates the unit. The same units as in the EXTRACT function are supported.</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">DATEDIFF</span><span class="p">(</span><span class="s1">'YEAR'</span><span class="p">,</span> <span class="n">T1</span><span class="p">.</span><span class="n">CREATED</span><span class="p">,</span> <span class="n">T2</span><span class="p">.</span><span class="n">CREATED</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="dayname">DAYNAME</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">DAYNAME</span><span class="p">(</span><span class="nb">date</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Returns the name of the day (in English).</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">DAYNAME</span><span class="p">(</span><span class="n">CREATED</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="day_of_month">DAY_OF_MONTH</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">DAY_OF_MONTH</span><span class="p">(</span><span class="nb">date</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Returns the day of the month (1-31).</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">DAY_OF_MONTH</span><span class="p">(</span><span class="n">CREATED</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="day_of_week">DAY_OF_WEEK</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">DAY_OF_WEEK</span><span class="p">(</span><span class="nb">date</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Returns the day of the week (1 means Sunday).</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">DAY_OF_WEEK</span><span class="p">(</span><span class="n">CREATED</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="day_of_year">DAY_OF_YEAR</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">DAY_OF_YEAR</span><span class="p">(</span><span class="nb">date</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Returns the day of the year (1-366).</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">DAY_OF_YEAR</span><span class="p">(</span><span class="n">CREATED</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="extract">EXTRACT</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="k">EXTRACT</span> <span class="p">(</span><span class="err">{</span><span class="n">EPOCH</span> <span class="o">|</span> <span class="nb">YEAR</span> <span class="o">|</span> <span class="n">YY</span> <span class="o">|</span> <span class="n">QUARTER</span> <span class="o">|</span> <span class="k">MONTH</span> <span class="o">|</span> <span class="n">MM</span> <span class="o">|</span> <span class="n">WEEK</span> <span class="o">|</span> <span class="n">ISO_WEEK</span> |
| <span class="o">|</span> <span class="k">DAY</span> <span class="o">|</span> <span class="n">DD</span> <span class="o">|</span> <span class="n">DAY_OF_YEAR</span> <span class="o">|</span> <span class="n">DOY</span> <span class="o">|</span> <span class="n">DAY_OF_WEEK</span> <span class="o">|</span> <span class="n">DOW</span> <span class="o">|</span> <span class="n">ISO_DAY_OF_WEEK</span> |
| <span class="o">|</span> <span class="n">HOUR</span> <span class="o">|</span> <span class="n">HH</span> <span class="o">|</span> <span class="k">MINUTE</span> <span class="o">|</span> <span class="n">MI</span> <span class="o">|</span> <span class="k">SECOND</span> <span class="o">|</span> <span class="n">SS</span> <span class="o">|</span> <span class="n">MILLISECOND</span> <span class="o">|</span> <span class="n">MS</span> |
| <span class="o">|</span> <span class="n">MICROSECOND</span> <span class="o">|</span> <span class="n">MCS</span> <span class="o">|</span> <span class="n">NANOSECOND</span> <span class="o">|</span> <span class="n">NS</span><span class="err">}</span> |
| <span class="k">FROM</span> <span class="nb">timestamp</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Returns a specific value from a timestamps. This method returns an <code>int</code>.</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="k">EXTRACT</span><span class="p">(</span><span class="k">SECOND</span> <span class="k">FROM</span> <span class="k">CURRENT_TIMESTAMP</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="formatdatetime">FORMATDATETIME</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">FORMATDATETIME</span> <span class="p">(</span><span class="nb">timestamp</span><span class="p">,</span> <span class="n">formatString</span> <span class="p">[,</span><span class="n">localeString</span> <span class="p">[,</span><span class="n">timeZoneString</span><span class="p">]])</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Formats a date, time, or timestamp as a string. The most important format characters are: <code>y</code> year, <code>M</code> month, <code>d</code> day, <code>H</code> hour, <code>m</code> minute, <code>s</code> second. For details about the format, see <code>java.text.SimpleDateFormat</code>. This method returns a <code>string</code>.</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">FORMATDATETIME</span><span class="p">(</span><span class="nb">TIMESTAMP</span> <span class="s1">'2001-02-03 04:05:06'</span><span class="p">,</span> <span class="s1">'EEE, d MMM yyyy HH:mm:ss z'</span><span class="p">,</span> <span class="s1">'en'</span><span class="p">,</span> <span class="s1">'GMT'</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="hour">HOUR</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">HOUR</span><span class="p">(</span><span class="nb">timestamp</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Returns the hour (0-23) from a timestamp.</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">HOUR</span><span class="p">(</span><span class="n">CREATED</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="minute">MINUTE</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="k">MINUTE</span><span class="p">(</span><span class="nb">timestamp</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Returns the minute (0-59) from a timestamp.</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="k">MINUTE</span><span class="p">(</span><span class="n">CREATED</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="month">MONTH</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="k">MONTH</span><span class="p">(</span><span class="nb">timestamp</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Returns the month (1-12) from a timestamp.</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="k">MONTH</span><span class="p">(</span><span class="n">CREATED</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="monthname">MONTHNAME</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">MONTHNAME</span><span class="p">(</span><span class="nb">date</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Returns the name of the month (in English).</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">MONTHNAME</span><span class="p">(</span><span class="n">CREATED</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="parsedatetime">PARSEDATETIME</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">PARSEDATETIME</span><span class="p">(</span><span class="n">string</span><span class="p">,</span> <span class="n">formatString</span> <span class="p">[,</span> <span class="n">localeString</span> <span class="p">[,</span> <span class="n">timeZoneString</span><span class="p">]])</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Parses a string and returns a <code>timestamp</code>. The most important format characters are: <code>y</code> year, <code>M</code> month, <code>d</code> day, <code>H</code> hour, <code>m</code> minute, <code>s</code> second. For details about the format, see <code>java.text.SimpleDateFormat</code>.</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">PARSEDATETIME</span><span class="p">(</span><span class="s1">'Sat, 3 Feb 2001 03:05:06 GMT'</span><span class="p">,</span> <span class="s1">'EEE, d MMM yyyy HH:mm:ss z'</span><span class="p">,</span> <span class="s1">'en'</span><span class="p">,</span> <span class="s1">'GMT'</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="quarter">QUARTER</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">QUARTER</span><span class="p">(</span><span class="nb">timestamp</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Returns the quarter (1-4) from a timestamp.</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">QUARTER</span><span class="p">(</span><span class="n">CREATED</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="second">SECOND</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="k">SECOND</span><span class="p">(</span><span class="nb">timestamp</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Returns the second (0-59) from a timestamp.</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="k">SECOND</span><span class="p">(</span><span class="n">CREATED</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="week">WEEK</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">WEEK</span><span class="p">(</span><span class="nb">timestamp</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Returns the week (1-53) from a timestamp. This method uses the current system locale.</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="n">WEEK</span><span class="p">(</span><span class="n">CREATED</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="year">YEAR</h2> |
| <div class="sectionbody"> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="nb">YEAR</span><span class="p">(</span><span class="nb">timestamp</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| <div class="paragraph"> |
| <p>Returns the year from a timestamp.</p> |
| </div> |
| <div class="dlist"> |
| <dl> |
| <dt class="hdlist1">Example: </dt> |
| </dl> |
| </div> |
| <div class="listingblock"> |
| <div class="content"> |
| <pre class="rouge highlight"><code data-lang="sql"><span class="nb">YEAR</span><span class="p">(</span><span class="n">CREATED</span><span class="p">)</span></code></pre> |
| </div> |
| </div> |
| </div> |
| </div> |
| </article> |
| <nav class="right-nav" data-swiftype-index='false'> |
| <ul class="sectlevel1"> |
| <li><a href="#current_date">CURRENT_DATE</a></li> |
| <li><a href="#current_time">CURRENT_TIME</a></li> |
| <li><a href="#current_timestamp">CURRENT_TIMESTAMP</a></li> |
| <li><a href="#dateadd">DATEADD</a></li> |
| <li><a href="#datediff">DATEDIFF</a></li> |
| <li><a href="#dayname">DAYNAME</a></li> |
| <li><a href="#day_of_month">DAY_OF_MONTH</a></li> |
| <li><a href="#day_of_week">DAY_OF_WEEK</a></li> |
| <li><a href="#day_of_year">DAY_OF_YEAR</a></li> |
| <li><a href="#extract">EXTRACT</a></li> |
| <li><a href="#formatdatetime">FORMATDATETIME</a></li> |
| <li><a href="#hour">HOUR</a></li> |
| <li><a href="#minute">MINUTE</a></li> |
| <li><a href="#month">MONTH</a></li> |
| <li><a href="#monthname">MONTHNAME</a></li> |
| <li><a href="#parsedatetime">PARSEDATETIME</a></li> |
| <li><a href="#quarter">QUARTER</a></li> |
| <li><a href="#second">SECOND</a></li> |
| <li><a href="#week">WEEK</a></li> |
| <li><a href="#year">YEAR</a></li> |
| </ul> |
| |
| |
| <footer> |
| </footer> |
| |
| </nav> |
| |
| </section> |
| <script type='module' src='/assets/js/code-copy-to-clipboard.js' async crossorigin></script> |
| |
| <script> |
| // inits deep anchors -- needs to be done here because of https://www.bryanbraun.com/anchorjs/#dont-run-it-too-late |
| anchors.add('.page-docs h1, .page-docs h2, .page-docs h3:not(.discrete), .page-docs h4, .page-docs h5'); |
| anchors.options = { |
| placement: 'right', |
| visible: 'always' |
| }; |
| </script> |
| <!-- load google fonts async --> |
| <script type="text/javascript"> |
| WebFontConfig = { |
| google: { families: [ 'Open+Sans:300,400,600,700&display=swap' ] } |
| }; |
| (function() { |
| var wf = document.createElement('script'); |
| wf.src = 'https://ajax.googleapis.com/ajax/libs/webfont/1/webfont.js'; |
| wf.type = 'text/javascript'; |
| wf.async = 'true'; |
| var s = document.getElementsByTagName('script')[0]; |
| s.parentNode.insertBefore(wf, s); |
| })(); </script> |
| <script src="https://cdn.jsdelivr.net/npm/docsearch.js@2/dist/cdn/docsearch.min.js"></script> |
| <script> |
| docsearch({ |
| // Your apiKey and indexName will be given to you once |
| // we create your config |
| apiKey: '25626fae796133dc1e734c6bcaaeac3c', |
| indexName: 'docsearch', |
| //appId: '<APP_ID>', // Should be only included if you are running DocSearch on your own. |
| // Replace inputSelector with a CSS selector |
| // matching your search input |
| inputSelector: '#search-input', |
| // Set debug to true to inspect the dropdown |
| debug: true, |
| }); |
| </script> |
| <script type='module' src='/assets/js/index.js?1598500267' async crossorigin></script> |
| <script type='module' src='/assets/js/versioning.js?1598500267' async crossorigin></script> |
| </body> |
| |
| </html> |