Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inserting date and money
Message
 
 
To
27/10/2008 19:40:46
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 6.5 and older
Miscellaneous
Thread ID:
01357541
Message ID:
01357544
Views:
10
It's other way around: dates has to be represented by strings and money should be passed as numbers.
'10/14/2008', '10/14/2008', 22222222, 1, 5.657, 123.456) 
>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.
>
>So how is the best way to save this type of fields in my SQL db?
>Thx.
>
>
>P.D.: My DB is SQL 2005
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform