|
Returns the number of milliseconds since
the epoch, given a time string.
SyntaxTime2Num(d [, f [, k ]])
Parameters
Parameter
|
Description
|
|---|
d
|
A time string in the format supplied by f that
also conforms to the locale given by k.
|
f (Optional)
|
A time format string. If you do not include
a value for f, the function uses the default time
format H:MM:SS A.
|
k (Optional)
|
A locale identifier string that conforms
to the locale naming standards. If you do not include a value for k,
or if k is invalid, the function uses the ambient
locale.
|
The function returns a value of 0 if
any of the following conditions are true:
The format
of the given time does not match the format specified in the function.
Either the locale or time format supplied in the function
is invalid.
Insufficient information is provided to determine
a unique time since the epoch (that is, any information regarding
the time is missing or incomplete.
ExamplesThe
following expressions illustrate using the Time2Num function:
Expression
|
Returns
|
|---|
Time2Num("00:00:00 GMT", "HH:MM:SS Z")
|
1
|
Time2Num("1:13:13 PM")
|
76393001 to a user in California
on Pacific Standard Time, and 76033001 when that
same user is on Pacific Daylight Savings Time.
|
Time2Num("13:13:13", "HH:MM:SS") - Time2Num("13:13:13 GMT", "HH:MM:SS Z")) / (60 * 60 * 1000)
|
8 to a user in Vancouver
and 5 to a user in Ottawa when on Standard Time.
On Daylight Savings Time, the returned values are 7 and 4, respectively.
|
Time2Num("13:13:13 GMT", "HH:MM:SS Z", "fr_FR")
|
47593001
|
|
|
|
