> Hello,
> In SQL, if I do
> Select cast (37797.8159722222 as datetime)as DateFromDecimal
> i get 2003-06-27 19:34:59.997 as the return.
>
> in VB.NET if I do:
>  Dim idate As Date
>  idate = Date.FromOADate(37797.8159722222)
> I get  6/25/2003 7:35:00 PM as the return.
>
>
> Any idea as to why I'm getting different day of the month?
>
> Any idea how I can get vb.net to return the time in the same precision
> as SQL?  VB.net appears to be rounding the time up to 7:35:00 PM
>
> Thanks!
>

> 1. An SQL DateTime is not an Automation date (the difference is 2 days),
> so to correct for this, add 2 to the double value in VB before
> converting it.
>
> 2. An SQL DateTime has a precision in milliseconds, VB in seconds, so,
> the rounding you mention is correct.
>
>
>
>
> a VB datetime is stored completely differently than SQL DateTimes, so,
> stored as a double
> rushaus***@gmail.com wrote:
> > Hello,
> > In SQL, if I do
> > Select cast (37797.8159722222 as datetime)as DateFromDecimal
> > i get 2003-06-27 19:34:59.997 as the return.
> >
> > in VB.NET if I do:
> >  Dim idate As Date
> >  idate = Date.FromOADate(37797.8159722222)
> > I get  6/25/2003 7:35:00 PM as the return.
> >
> >
> > Any idea as to why I'm getting different day of the month?
> >
> > Any idea how I can get vb.net to return the time in the same precision
> > as SQL?  VB.net appears to be rounding the time up to 7:35:00 PM
> >
> > Thanks!
> >