LibraryActive

SQLite Date and Time Functions

Seven scalar date/time functions for SQLite: date, time, datetime, julianday, unixepoch, strftime, and timediff.

Field note

What it does

Built-in SQL functions for parsing, formatting, and converting dates and times across ISO-8601, Julian day, and Unix timestamp formats without a dedicated date/time datatype.

Capabilities

Available capabilities

Time formatting DateTime conversion Julian day conversion Time difference calculation Unix timestamp conversion Date Formatting

SQLite Date and Time Functions

What it does

Available capabilities

Tags

Ways to use it

Product features

1.0 Overview

2.0 C/C++ Interface

2.1 Opening and closing a database

2.2 Executing SQL statements

2.3 User-defined functions

2.4 User-defined collating sequences

C/C++ Interface For SQLite Version 3