• Registered: 2014-12-24
  • Posts: 39

Topic: about date field on sql query

Hi,
i am using a button with sqlquery action
when click on button i want ->      list all orders older than 15 days. so i used this query

SELECT *
FROM siparis
WHERE (julianday('now') - julianday(orderday))>14;


result comes but it looks like below
2016-08-03 00:00:00.000

what i want is 03-08-2016 only

Another qustion.
i want  orders older tha 15 days with the name of person

person name is in person table.
how can i get person.name and orders older than 15 days with one query?


attached my files

teslimtarihi: orderdate
kim : person table
siparis : order table

Post's attachments

Attachment icon ordertrack.rar 8.35 kb, 727 downloads since 2016-10-05 

  • Registered: 2014-12-24
  • Posts: 39

Re: about date field on sql query

form name is frmBorclar.
sql query Button is on the bottom of form

  • Registered: 2014-02-14
  • Posts: 10,294

Re: about date field on sql query

You can do it without SQL query.


You should open property "Settings" and use option "3. Filter":

odendimi = 0 AND ((julianday('now') - julianday(siparistarihi))>14)


But if you need SQL for that, example:

SELECT

kim.isim,
(select kim.isim from kim where kim.id = siparis.id_kim1),

strftime('%d-%m-%Y', siparis.siparistarihi),
siparis.istenenurun,
siparis.fiyat,
strftime('%d-%m-%Y', siparis.teslimtarihi),
strftime('%H:%M:%S', siparis.teslimsaati),
siparis.teslimaldimi,
siparis.tepsigeldimi,
siparis.odendimi,
siparis.aciklama,
siparis.record_count

FROM siparis

LEFT OUTER JOIN kim ON kim.id=siparis.id_kim

WHERE (julianday('now') - julianday(teslimtarihi))>14;
Dmitry.