SQL•SQL References

MS Access TimeValue() Function

Example

SELECT TimeValue("17:15:38");

Definition and Usage

The TimeValue() function returns a time based on a string.

Syntax

TimeValue(
string
)

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

Works in:	From Access 2000

Loading lesson path

SQL•SQL References

Example

SELECT TimeValue("17:15:38");

The TimeValue() function returns a time based on a string.

Syntax

TimeValue(
string
)

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

Works in:	From Access 2000