Skip to content

🐛 Bug: DATETIME_DIFF Function's result incorrect in SQLite #4816

@ozcpa

Description

@ozcpa

Please confirm if bug report does NOT exists already ?

  • I confirm there is no existing issue for this

Steps to reproduce ?

In the new version (0.101.0) just released, the DATETIME_DIFF function calculates incorrectly. For example:
DATETIME_DIFF("2023-01-12", "2021-08-29", "years") is calculating a result of 2, but it should be 1

Desired Behavior

Function should behave correctly in SQLite

Project Details

Node: v16.16.0
Arch: x64
Platform: win32
Docker: false
RootDB: sqlite3
PackageVersion: 0.101.0

Attachements

No response

Metadata

Metadata

Assignees

Labels

🐛 Type: BugSomething is broken or incorrect unexpectedly.

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions