Convert datetime to integer

[jtarry]

I wish to update a table with an integer showing the difference between two dates.

update table
set fieldint = date1 - date2

Thanks

 

[bborissov]

Check DateDiff() function in BOL.
BTW Date2 - Date1 is also valid expression. That will give you difference between two datetime fields in days.

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[markros]

Boris,

Try

declare @d date = getdate(), @d2 date
set @d2 = GETDATE() - 10
select @d - @d2

Check then

http://blogs.lessthandot.com/index....operand-type-clash-date-is-incompatible--2008

PluralSight Learning Library

 

[bborissov]

Did I said date?
I said datetime, isn't it?

But BTW I was wrong.

Date2 - Date1 = datetime

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[jtarry]

Have have resolved my problem with DateDiff() function by inserting into a varable

Thanks