title: Timestamp: How do I extract the individual component in a timestamp field in Oracle NoSQL Database?
body: <p>I am exploring the SQL queries on JSON documents that has a timestamp field called lastVisited.</p>
  <p>Here's an example:</p>
  <pre><code>    &quot;lastVisited&quot; : &quot;2020-11-21T20:33:39.8125&quot;
  </code></pre>
  <p>My application would like to extract individual component of the timestamp. For example, we want to individually extract the year, month, day, hour, and minute.</p>
  <p>Does Oracle NoSQL Database support functions that do that?</p>