Jump to content
Fórum Script Brasil
  • 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  



  • Forum Statistics

    • Total Topics
      148420
    • Total Posts
      643847
×
×
  • Create New...