Skip to content

BUG: DateTime filters #63

Description

@PunamDamania

DateTime filters are truncating time.

passedValue: 2023-06-29T14:00:00.000Z&2023-06-30T14:00:00.000Z
Generated Query:
WHERE CONVERT(date, [t].[colName]) >= '2023-06-29T00:00:00.0000000+01:00' AND CONVERT(date, [t].[colName]) <= '2023-06-30T00:00:00.0000000+01:00'

passed Value : 2023-06-29T13:00:00.000Z
Generated Query:
WHERE CONVERT(date, [t].[colName]) = '2023-06-29T14:00:00.0000000+01:00'

Metadata

Metadata

Labels

bugSomething isn't working

Type

No type

Fields

No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions