Skip to content

[BUG] Missing function: previous_day #613

Closed
@rampage644

Description

@rampage644

Function: previous_day
Category: Date & time
Status: Failed (Return Code: 1)
Documentation: https://docs.snowflake.com/en/sql-reference/functions/previous_day

Test SQL:

SELECT PREVIOUS_DAY('2025-05-01'::date, 'SUN');

Expected Result:

N/A

Actual Result:

SELECT PREVIOUS_DAY('2025-05-01'::date, 'SUN');

Stderr:

╭─ Error ─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────╮
│ 000200: 200: DataFusion error: Error during planning: Invalid function 'previous_day'.                                                                      │
│ Did you mean 'today'?                                                                                                                                       │
╰─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────╯

Parent EPIC: #515

Metadata

Metadata

Assignees

Labels

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions