Saturday, February 25, 2012

Problem with DateTime

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?
>

No comments:

Post a Comment