<div>
Have you tried the juliandate function?<br />
<br />
juliandate(er.rental_end_d<wbr />ate) - juliandate(er.rental_start<wbr />_date)
</div>


Have you tried the juliandate function?

juliandate(er.rental_end_date) - juliandate(er.rental_start_date)

<div>
How did it not work? <br />
<br />
What data type are the fields <b>rental_end_date</b> and <b>rental_start_date</b>?
</div>


How did it not work?

What data type are the fields rental_end_date and rental_start_date?

<div>
Oops, didn't notice my typo - of course it should be <b>julianday </b> not <b>juliandate. </b>
</div>


Oops, didn't notice my typo - of course it should be julianday not juliandate.

<div>
julianday worked well.<br />
Thank everyone
</div>


<div>
Welcome. Glad to help as always.
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
I have a query who works fine in oracle sql and give me the amount of days between 'er.rental_end_date' and 'er.rental_start_date'.<br />
I need it to work on sqlite, but there I always get a '0', plus the '1' that I add in the query, then I always get one.<br />
Can someone help please.<br />
Thank you.<br />
<br />
select er.*,p.user_def_num1 power_consumption, <br />
(cast(er.rental_end_date-e<wbr />r.rental_s<wbr />tart_date as decimal)+1) rental_days, <br />
(cast(er.rental_end_date-e<wbr />r.rental_s<wbr />tart_date as decimal)+1) * 24 * p.user_def_num1 total_power <br />
from c_equipment_rental er, product p <br />
where er.product_id = p.product_id and er.request_id = '{0}'
</div>
</div>


Hello,
I have a query who works fine in oracle sql and give me the amount of days between 'er.rental_end_date' and 'er.rental_start_date'.
I need it to work on sqlite, but there I always get a '0', plus the '1' that I add in the query, then I always get one.
Can someone help please.
Thank you.

select er.*,p.user_def_num1 power_consumption, 
(cast(er.rental_end_date-er.rental_start_date as decimal)+1) rental_days, 
(cast(er.rental_end_date-er.rental_start_date as decimal)+1) * 24 * p.user_def_num1 total_power 
from c_equipment_rental er, product p 
where er.product_id = p.product_id and er.request_id = '{0}'

Calculate the amount of days between two dates in sqlite

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.