Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

MySQL CURRENT_TIME() Function

Concept visual

MySQL CURRENT_TIME() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return current time:

SELECT CURRENT_TIME();

Definition and Usage

The CURRENT_TIME() function returns the current time.

Note:

The time is returned as

Formula

"HH - MM - SS" (string) or as HHMMSS.uuuuuu (numeric).

Note:

This function equals the CURTIME() function.

Syntax

CURRENT_TIME()

Technical Details

Works in:

From MySQL 4.0

More Examples

Example

Return current time + 1:

SELECT CURRENT_TIME() + 1;

MySQL CURRENT_TIME() Function

Concept visual

MySQL CURRENT_TIME() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return current time:

SELECT CURRENT_TIME();

Definition and Usage

The CURRENT_TIME() function returns the current time.

Note:

The time is returned as

Formula

"HH - MM - SS" (string) or as HHMMSS.uuuuuu (numeric).

Note:

This function equals the CURTIME() function.

Syntax

CURRENT_TIME()

Technical Details

Works in:

From MySQL 4.0

More Examples

Example

Return current time + 1:

SELECT CURRENT_TIME() + 1;

MySQL CURRENT_TIME() Function

MySQL CURRENT_TIME() Function

Example

Return current time:

Definition and Usage

Note:

The time is returned as

Note:

Syntax

Technical Details

Works in:

More Examples

Example

Return current time + 1:

Previous

Next

MySQL CURRENT_TIME() Function

MySQL CURRENT_TIME() Function

Example

Return current time:

Definition and Usage

Note:

The time is returned as

Note:

Syntax

Technical Details

Works in:

More Examples

Example

Return current time + 1:

Previous

Next