PostgreSql Select from where date = current Date

Question

how can i select only the records from DB where the Data (Date in portuguese) = the current date

SELECT id, data, dia, mes, ano,fornecedor, doc, valor_líquido, total
FROM public.fluxo_pagamentos where data = current_date;

What is the issue with your query?

Gordon Linoff
– Gordon Linoff

2018-01-25 13:34:34 +00:00
Commented Jan 25, 2018 at 13:34 — Gordon Linoff
– Gordon Linoff, Commented Jan 25, 2018 at 13:34

Y.S · Accepted Answer · 2018-01-25 13:51:50Z

11

cast to date and use now()

SELECT id, data, dia, mes, ano,fornecedor, doc, valor_líquido, total
FROM public.fluxo_pagamentos where data::date = now()::date;

answered Jan 25, 2018 at 13:51

Y.S

1,8623 gold badges18 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Daniel Lidström Over a year ago

This is beautiful. Simple, straight to the point.

Gordon Linoff · Accepted Answer · 2018-01-25 13:35:35Z

6

I may suspect that data has a time component. If so, try:

where data >= current_date::timestamp and
      data < current_date::timestamp + interval '1 day'

answered Jan 25, 2018 at 13:35

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

3 Comments

Leogreen Over a year ago

ERROR: operator does not exist: character varying >= timestamp without time zone LINE 2: FROM public.fluxo_pagamentos where data >= current_date::ti... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. SQL state: 42883 Character: 111

Gordon Linoff Over a year ago

@Leogreen . . . Fix your data so dates are stored using an appropriate type.

Daniel Lidström Over a year ago

This is complex. Use the other answer.

Collectives™ on Stack Overflow

PostgreSql Select from where date = current Date

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related