• 0
Sign in to follow this  
Jose Luiz medeiros

Consulta numa data incrementada

Question

boa tarde,
preciso fazer uma consulta no mysql que me retornasse os registro de uma data mais dias que precisasse:
select * from contas_receber where datavencimento = current_date + 30
nesse caso estou precisando trazer todas as contas a vencer nos proximos 30 dias,

alguém pode me ajudar?

grato:

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Procure no manual do mysql a função DATE_ADD

DATE_ADD(CURDATE(), INTERVAL 30 DAY)

ou

DATE_ADD(CURDATE(), INTERVAL 1 MONTH)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this