How to use strftime function in sqlite

Question

1.00/5 (1 vote)

See more:

1) Use the strftime function with the date 2019-04-01 and display the date along with the time.

2) Use THE strftime function with the date 2019-04-01 and add 2 years to the given date, add 180 minutes to that date.

What I have tried:

1) select strftime('%Y-%m-%d %H:%M:%S','2019-04-01');

2) select strftime('%Y-%m-%d %H:%M:%S','2019-04-01','+2 years','+180 minutes');

Posted 3-Jul-19 21:28pm

Tej K

Updated 27-Sep-19 1:03am

Add a Solution

Comments

CHill60 4-Jul-19 3:31am

And what is your question?

Tej K 4-Jul-19 3:45am

What i tried was correct or wrong?

CHill60 4-Jul-19 3:47am

What happens when you run it?

2 solutions

Solution 4

You can try this, it worked

SELECT strftime ('%Y-%m-%d %H:%M:%S','2019-04-01','+2 year','+180 minute');

Posted 27-Sep-19 1:04am

Member 14605708

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2019-07-03T22:05:00

Quote:
What i tried was correct or wrong?

We aren't here to test your homework: that's really up to you.
So load up an SQLite manager (I use SQLiteStudio: SQLiteStudio[^]) and test it!
Run your queries, and check if what it returns matches what your tutor has asked you to produce. If it exactly does, then it's right. Otherwise ... you can guess the rest!