SQLite datetime Function

The SQLite datetime function is used to retrieve date and time in different format. The result format of datetime function is 'YYYY-MM-DD HH:MM:SS'.

Syntax:

Example1: Retrieve current date and time:

Output:

SQLite Datetime function 1

Example2: Add/ subtract years to current date and time:

Output:

SQLite Datetime function 2 SQLite Datetime function 3

Example3: Add/ subtract days to current date and time:

Output:

SQLite Datetime function 4 SQLite Datetime function 5 SQLite Datetime function 6

Example4: Add/ subtract hours to current date and time:

Output:

SQLite Datetime function 7 SQLite Datetime function 8 SQLite Datetime function 9

Example5: Add/ subtract minutes to current date and time:

Output:

SQLite Datetime function 10 SQLite Datetime function 11
Next TopicSQLite Juliandday




Latest Courses

Logo

We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks

Contact info

G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India

[email protected].

Follow us
FacebookTwitterRssBlogspotYoutube
Tutorials
Java Data Structures C Programming C++ Tutorial C# Tutorial PHP Tutorial HTML Tutorial JavaScript Tutorial jQuery Tutorial Spring Tutorial
Interview Questions
Tcs Intuit Wipro Adobe Infosys Amazon Accenture Cognizant Capgemini Microsoft
Online Compiler
C R C++ Php Java Html Swift Python JavaScript TypeScript
© Copyright 2024 Javatpoint. All Rights Reserved.