best way to show seconds from 1970

[gagz]

is there a way in .net (like in perl or php) to give a numeric time values as seconds or milliseconds from 1/1/1970?

 

[Custom24]

datediff(dateinterval.second, #1/1/1970#, now)

Mark

 

[gagz]

cool... now, jsut because i found it, i'm doing:

Dim dtID As DateTime = DateTime.Now()
dr(0) = dtID.Ticks

do you think any is better than the other? Ticks is a large number since its from 0001 ( i think)

 

[Custom24]

Well, datediff specifically looks at difference between two dates. Ticks, according to the help, is the number of 100 nanosecond intervals (the Windows clock tick time) between now and Jan1, 0001 (I've worked it out - it's correct). So depends what you want. I guess ticks is good for generating numbers which will not be repeated on a particular machine.
I've just done a little test and those numbers seem to be only accurate to the last but two significant figures, so I'm not sure if .net is really able to get it this precisely. You might want to do a test to see if it is going to cause you a problem.
Or you may prefer a different method of generating an ID. Is this for an RDBMS?



Mark