• 0
Sign in to follow this  
lcarlos

Consulta Sql (Resolvido)

Question

Estou usando a consulta SQL abaixo para buscar em um campo data no formato dd/mm/yy os dias que coincidem com a data atual, mas está dando erro. Qual é o erro? Grato.

('select * from agenda where data = formatdatetime('dd/mm/yy', (date)')

Share this post


Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 0

Olá,

Tenta isso:

SQL.Add('SELECT * from agenda Where Data like'+QuotedStr(FormatDateTime('dd/mm/yy',now)));

Obs: eu usei now, para testar com a data do sistema.

Abs.

Kiko

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Sign in to follow this