[AccessD] Access to the millisecond (was: Harkins and Brock)

Hi all

For the archive, here's the direct link to the article:

  http://www.devx.com/dbzone/Article/39046

and this is the list of functions included:

Msec() is the core function. It generates the current time with millisecond resolution and returns current (local) date/time, including millisecond. 
DatePartMsec() extracts milliseconds or decimal seconds, as well as all the standard date/time parts from a date/time value. 
DateAddMsec() adds milliseconds or decimal seconds, as well as all the standard date/time intervals to a date/time value. 
DateDiffMsec() calculates the difference in milliseconds or decimal seconds between two date/time values. 
MsecDiff() returns the difference in milliseconds between two date/time values. 
TimeMsec() returns current (local) date/time, including millisecond as a time value that includes milliseconds. 
NowMsec() returns current (local) date/time, including millisecond as a full date/time value that includes milliseconds. 
TimerMsec() returns count of seconds from midnight with millisecond resolution. 
Millisecond() returns the millisecond part from a date/time value. 
SecondMsec() returns the second and the millisecond from a date/time value as a decimal value. 
MsecSerial() returns the date/time value of a numeric (double) input rounded to integer milliseconds relative to a base date. 
TimeSerialMsec() returns the date/time value of the combined parameters for hour, minute, second, and millisecond. 
MsecValueMsec() extracts the millisecond time part from a string expression. 
ExtractMsec() returns millisecond the date/time value from the last digits of a string. 
CDateMsec() converts a date/time expression including millisecond to a date/time value. 
CVDateMsec() converts a date/time expression including millisecond or a number to a date/time value. 
IsDateMsec() checks an expression if it represents a date/time value with or without a millisecond part. 
DateValueMsec() cleans a string for a time part including milliseconds. It also returns the date value of the string. 
TimeValueMsec() cleans a string for a millisecond part. 
StrDateFull() returns a date/time value formatted as to the current settings for Short Date and Long Time with trailing milliseconds formatted as a fixed-length numeric string. 
StrDateMsec() returns milliseconds of a date/time value as a "000" formatted string. 
FormatMsec() returns a value as a string formatted with milliseconds or any other value using Format. 
StrDateIso8601Msec() returns a value as a string formatted with milliseconds according to ISO-8601. 
DateSumDates() adds or subtracts partial date/time values to create a compound date value. 
TimeSerialFull() returns correct numeric negative date/time values, which TimeSerial() does not. 
DateValid() returns invalid numeric negative date/time values less than one day as their positive equivalents. 
DateLinear() converts a native date/time value and returns the linear date value. 
DateNative() converts a linear date value and returns the native date value. 
DateMsecSet() rounds off a date/time value to the second and optionally adds specified millisecond part up to and including 999 milliseconds. 
SplitDateMsec() splits a date/time value into its components of date/time and millisecond as date/time values. 
JoinDateMsec() joins an array of date/time and millisecond as date/time values to a compound date/time value. 
DateSort() returns a continuous value including milliseconds that can be sorted on correctly even for negative date values. 
DateTimeRound() returns a date/time rounded off to the second by removing a millisecond portion. 
DateTimeRoundMsec() returns a date/time value rounded to the nearest millisecond approximately by 4/5. 

/gustav


>>> ssharkins at gmail.com 12-09-2008 00:12 >>>
http://www.devx.com/ 

I just wanted to share this article with you guys -- Gustav and I have 
written a number of articles together but this one's different as I had to 
ask him repeatedly... "uh... huh????" :)

I think it turned out really well and certainly will be useful to the 
developers who actually need it.

Susan H.