How do I add to the date in a select query in SQL Server? -


apologies unclear question unsure of how title this. new sql server. have 2 columns in table, 1 called datetimerented , 1 called datetimereturned. want have select query calculates movies overdue (+48hrs) along lines of:

select * ---- [where datetimereturned datetimerented + 2 days] --- this. 

i want know need work out, thank :)

use dateadd (transact-sql)

for example:

where datetimereturned > dateadd(day, 2, datetimerented) 

Comments

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

javascript - Add class to another page attribute using URL id - Jquery -

firefox - Where is 'webgl.osmesalib' parameter? -