thank you OJ and Jens,
As i said I am not very familiar with either SQL Server nor ADO.NET except
the basics.
In the Ent. Manager interface my field is of type smalldatetime.
I cant really show you the code because its quite big and at various places,
however as I said:
1) I construct the SQL query as a sString. (this *same one* I copy and paste
from a textbox into the Query Analyzer and get the datetime *complete* with
the hour part)
2) I create a dataset and then bind it to a datagrid.
Of course the results agree and there is no problem except ... i miss the
hour part in the datagrid!
Maybe I should specify it on the SQL string itself.
BTW, i noticed the when i multiply two real valurs I get some weird result:
e.g. 0.1 X 2.34 = 0.234000005 , is this some kind of internal round off
error from the server? And, what is the simplest way to round values? I
currently use cast( .... as numeric (5,3)).
Is there a simpler way to get two decimals?
TIA again!!!
-steve
"Jens Süßmeyer" <Jens@Remove_this_For_Contacting.sqlserver2005.d e> a écrit
dans le message de news:
uh*************@TK2MSFTNGP15.phx.gbl...
Thats probably the cause of the interface ADO.NET, it depends wheter you
get these values and cast it to ^what kind of .NET Type. If you could
tell, that´ll help us in sql server group.
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
"steve" <st***@here.com> schrieb im Newsbeitrag
news:9E*******************@weber.videotron.net... Hi,
First my apologies for double-posting but I am not sure wether this is a
VB.Net or TSQL problem.
I have the following problem:
I generate a T-SQL string in order to fill my Dataset and consecuently a
Datagrid.
However on the date_time column only the date part is showing : e.g.
2004-08-14
Instead of the date and the time: e.g. 2004-08-14 02:12:06
The *same* string run at the SQL Server's Query analyzer will give *both*
parts in the date-time column.
TIA for your help
-steve