C
Chris
Hi all,
I have a smalldatetime field startDate, endDate.
update myTab set endDate = Datedd(mi, 12.56*60, startDate)
WHERE (any condition)
this works fine and returns value 12.55 when a 'select' statement with
some function is executed.
But when i write the above statement in a procedure, and then pass
12.56 as parameter, it rounds its and gives '13' (instead of 12.55,
which i get when i run it using the above update statement.) for the
same select statment..
Any idea, why is it so??
TIA
I have a smalldatetime field startDate, endDate.
update myTab set endDate = Datedd(mi, 12.56*60, startDate)
WHERE (any condition)
this works fine and returns value 12.55 when a 'select' statement with
some function is executed.
But when i write the above statement in a procedure, and then pass
12.56 as parameter, it rounds its and gives '13' (instead of 12.55,
which i get when i run it using the above update statement.) for the
same select statment..
Any idea, why is it so??
TIA