Skip to content
ScopeDBDocs
GuidesScopeQLAPI referenceRelease notes
Sign inStart free
ScopeDBDocs
Sign inStart free
  • Overview

  • Data model

    • Data types
    • Date and time
    • Semi-structured
    • Conversion
    • Computed columns

  • Commands

    • Overview
    • Query syntax
    • Query operators
      • Overview
      • Arithmetic
      • Comparison
      • Logical
      • Set operators
    • DDL
      • Overview
      • CREATE DATABASE
      • DROP DATABASE
      • CREATE SCHEMA
      • DROP SCHEMA
      • CREATE TABLE
      • DROP TABLE
      • ALTER TABLE
      • CREATE VIEW
      • DROP VIEW
      • SHOW TABLES
      • DESCRIBE TABLE
      • CREATE INDEX
      • DROP INDEX
    • DML
      • Overview
      • INSERT
      • DELETE
      • UPDATE

  • Functions

    • Overview
    • Aggregate
      • Overview
      • approx_count_distinct
      • approx_quantile
      • array_agg
      • avg
      • count
      • count_distinct
      • first, first_value
      • last, last_value
      • max
      • max_by
      • min
      • min_by
      • mode
      • object_agg
      • quantile
      • schema
      • stddev_pop
      • stddev_samp
      • sum
      • variance_pop
      • variance_samp
    • Conditional expression
      • Overview
      • IS [ NOT ]
    • Conversion
    • Date and time
      • Overview
      • ceil, floor
      • strftime, strptime
      • now
      • trunc
    • Numeric
      • Overview
      • abs
      • ceil
      • floor
      • ln, log
      • round
      • trunc
    • String
      • Overview
      • || (string concatenation)
      • contains
      • ends_with
      • length
      • lpad, rpad
      • ltrim
      • lower
      • md5
      • regexp_extract, regexp_extract_all
      • regexp_like
      • regexp_replace
      • repeat
      • replace
      • reverse
      • rtrim
      • search
      • search_ip
      • split
      • starts_with
      • String slicing
      • tokenize
      • trim
      • upper
    • Semi-structured data
      • Overview
      • {} (object construction)
      • [] (array construction)
      • [] (element access)
      • Array slicing
      • || (arrays and objects)
      • append
      • contains
      • dedup
      • exclude
      • keys
      • length
      • parse_json
      • to_json
      • typeof
    • Window
      • Overview
      • lag, lead
      • row_number
    • System
      • Overview
      • version
  1. ScopeQL
  2. Functions

Date and time functions

On this page
  • List of functions

Date and time functions support analysis of events over time. For the underlying value types, see date and time data types.

List of functions

  • ceil, floor
  • now
  • strftime, strptime
  • trunc

On this page

  • List of functions
ScopeDB

Build

ScopeDB CloudPricingDocsGitHub

Explore

BlogBrand kitComponent library

Connect

CommunityContact usFeedback

© 2024–2026 ScopeDB. All rights reserved.