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