DATEDIFF puzzle

[elmo29]

I have an internal variable in a stored procedure holding the number of seconds between one number and another

DECLARE @Variable int
SET @variable = DATEDIFF(second, @date1, @date2)

INSERT test(value)VALUES(@variable)

gives me 0, while

INSERT test(value)VALUES(DATEDIFF(second, @date1, @date2))

gives me the correct value

...... why?????
[sig][/sig]

 

[foxdev]

Probably because the interval is less than 1, and an integer only holds....integers. Try defining the variable and column as decimal(10,4). [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]