Skip to content

Relative Date time MYSQL format broken for DATE_SUB #1286

@vaghul

Description

@vaghul

Describe the bug
When selecting relative Data time option the Subtract 'x' days does not respond with accurate mysql query

To Reproduce

  1. Go to Demo Builder
  2. Clear all pre build rules
  3. select Datetime from the field selection
    4.Select relative RHS option
  4. Change the op to '+' and '-' both returns same SQL

Expected behavior
'+'. should have DATE_ADD while '-' should have DATE_SUB or

  • should have an positive interval while - should have negative interval

Screenshots

Image Image

Metadata

Metadata

Assignees

Labels

onlydust-waveContribute to awesome OSS repos during OnlyDust's open source week

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions