SQL•SQL References

MySQL TIME_TO_SEC() Function

Example

SELECT TIME_TO_SEC("19:30:10");

Definition and Usage

The TIME_TO_SEC() function converts a time value into seconds.

Syntax

TIME_TO_SEC(
time
)

Parameter	Description
time	Required. The time value

Works in:	From MySQL 4.0

Loading lesson path

SQL•SQL References

Example

SELECT TIME_TO_SEC("19:30:10");

The TIME_TO_SEC() function converts a time value into seconds.

Syntax

TIME_TO_SEC(
time
)

Parameter	Description
time	Required. The time value

Works in:	From MySQL 4.0