Postgress query date does not work

Questions
1

image
image1356×688 34.9 KB

Information on your n8n setup

  • **n8n version:Version 1.4.0
  • Database (default: postgres):
  • n8n EXECUTIONS_PROCESS setting (default: main):
  • Running n8n via (Docker):
  • **Operating system:ubunto 20.04
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hey @Ruan17,

If you manually run that query what would you expect the result to be?

4

image
image1781×491 47 KB

COMES NORMALLY

5

image
image1306×635 29.6 KB

the variables are not working

6

Have you tried adding a new Postgres node to see if that is working?

1 Like
7

image
image1725×874 48 KB

Actually, it was an old knot, I placed a new one and worked

3 Likes
8

This topic was automatically closed 7 hours after the last reply. New replies are no longer allowed.