Multi tool use

How to get previous day via SQLite in Swift

I have a sqlite table with a number of dates. I would like to execute a query to select those records where the Date is the previous date. I have tried the following but it doesn't work:

SELECT SUM(Amount) AS TOTAL FROM (SpentAmount) Where Date ='(Date().yesterday)'"


and output is : '2018-07-02 05:43:16 +0000'

'2018-07-02 05:43:16 +0000'

But I want only date and this format: '02-07-2018'.

'02-07-2018'

And I m trying This : SELECT SUM(Amount) AS TOTAL FROM SpentAmount WHERE Date = DATE('now', '-1 days');

but this Query give me no result

This is my database Database
but when i execute the query then give me this result

02-07-2018

1 Answer
1

If you want to target yesterday (i.e. the date before today), then use DATE('now', '-1 days'):

DATE('now', '-1 days')

SELECT SUM(Amount) AS TOTAL
FROM SpentAmount
WHERE Date = STRFTIME('%d.%m.%Y', DATE('now', '-1 days'));


As a general comment, your current date format is very non ideal. It will be very hard to sort your table by date. Instead, you should always store your date information in ISO format with SQLite, i.e. use 2018-07-02, not 02-07-2018.

2018-07-02

02-07-2018

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.