After Retriveing DateTime data from sql server 2005 through vb.net 2003,the
value of miilSecond Part of the datetime is different from one shown in
database.
ex:
when i use sql query in query analyzer ,the value returns 04:32:00.140
when same query executing through vb.net ,the value returns 04:32:00.320Can you post the query that you are using to retrieve the data?|||select dbo.ToDate(<field> ) from <Table>
Here ToDate is user defined function and field is bigInt dataType.
"Omnibuzz" wrote:
> Can you post the query that you are using to retrieve the data?
>|||Can you post the function definition?|||sorry
what written in sql server,same written in .net.
"Omnibuzz" wrote:
> Can you post the function definition?
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment