Example
Return a time based on the given string:
sql
SELECT TimeValue("17:15:38");
Definition and Usage
The TimeValue() function returns a time based on a string.
Syntax
text
TimeValue(string)
Parameter Values
| Parameter | Description |
|---|---|
| string | Required. A string that represents a time (from 0:00:00 to 23:59:59) |
Technical Details
| Works in: | From Access 2000 |
|---|
More Examples
Example
Return a time based on the given string:
sql
SELECT TimeValue("5:15:38 PM");