Max Wanadoo
max.wanadoo at gmail.com
Fri Sep 12 06:21:11 CDT 2008
hmmm this has set me thinking.... Where do I get a brain similar to Gustav's? Really clever stuff... Max On Fri, Sep 12, 2008 at 12:07 PM, Gustav Brock <Gustav at cactus.dk> wrote: > 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. > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >