Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
Text lesson

TimeValue

Example

Convert a string representation into a time value.

SELECT TimeValue(“17:15:38”);

Definition and Usage

The TimeValue() function converts a string into a time value.

Syntax

TimeValue(string)

Parameter Values

Parameter

Description

string

Required. A string representing a time within the range from 0:00:00 to 23:59:59

Technical Details

WORKS IN

From Access 2000

More Examples

Example

Convert the provided string into a corresponding time value.

SELECT TimeValue(“5:15:38 PM”);