sqlite3 and Python: date modifier

Question

When modifying the date of a column on python with sqlite3 I receive the None value.

datetime(Date, '+4 months')

works, but

datetime(Date, '+' || Test || 'months')

does not and sends me back None value. Test is an integer datatype column.

Any idea?

unutbu · Accepted Answer · 2018-02-13 21:14:02Z

1

Add a space before months:

% sqlite3
sqlite> select datetime('2018-02-13', '+' || 4 || ' months');
2018-06-13 00:00:00
sqlite> select datetime('2018-02-13', '+' || 4 || 'months'); 

sqlite>

answered Feb 13, 2018 at 21:14

unutbu

886k197 gold badges1.9k silver badges1.7k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sqlite3 and Python: date modifier

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related