Convert OLE date, OLE time to a datetime object
Posted on 2006-06-30
Hey guys, I'm importing data from a foxpro database into Sql Server 2005 using vb.net.
I have two database columns, a date, and a time, which I need to convert (SAFELY) to a .net DateTime object.
I was thinking of just directly equating the DateTime = dr("Date")
then doing a parse of the time.tostring to correctly obtain the time information.
Is this the best way to do this, or have I missed a good little function for this? I'm watching this like a hawk :)