Cor Ligthert [MVP]
4/13/2005 10:10:00 AM
John,
The datetime format is a long that exist from ticks. For the SQLserver
datetime there is a different starting point than for the system.datetime.
The first start with the Georgian calendar in 1753 and the other in the year
1. (1753 was the point where the UK (and therefore there colonies) switched
from Julian to Georgian)
With CDate that is converted right so that is not the problem.
When you want the date as value, than you can use something like this
roughly written
\\dim dtFromSQL as datetime = CDate(dr("DateTime"))
dim dtLong as long = dtfromSQL.Ticks
///
I hope this helps,
Cor