THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access TimeValue() Function

❮ MS Access Functions

Example

Convert a string to a time:

SELECT TimeValue("17:15:38");
Try it Yourself »

Definition and Usage

The TimeValue() function converts a string to a time.

Syntax

TimeValue(string_time)

Parameter Values

Parameter Description
string_time Required. A string that represents a time (from 0:00:00 to 23:59:59)

Technical Details

Works in: Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

More Examples

Example

Convert a string to a time:

SELECT TimeValue("5:15:38 PM");
Try it Yourself »

❮ MS Access Functions