Edgar,
Run this code in a query window to gain some insight into what SQL is doing
select 10/14/2008
you'll get 0, because it integer divided 10 by 14 and then divided that by 2008, and as for why you see that date:
select cast( 0 as smalldatetime )
Smallmoney has 4 digits to the right of the decimal point like money. The difference between the two datetypes is in the number of digits to the left of the decimal point. This is why you see the extra 0.
SQL server has a defined list of type conversions that it will go through to change one datatype to another, you should check the topic in the help file.
>Hello, I'm trying to save data with this query:
>
>Insert into Propuesta (idprospecto, Objeto, fecharecibo, fechaentrega,
>idusuario, idestado, presupuestocop, presupuestousd ) values ('1', 'esta es
>la prueba para la empresa de telecomunicaciones de bogota, del sector publico
>y con el id 1', 10/14/2008, 10/14/2008, 22222222, 1, '5.657', '123.456')
>
>this is the data saved for the date and money and smallmoney fields:
>
>01/01/1900 12:00:00 am for both and 5,6570 and 123,4560 for money and
>smallmoney respectively.