Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

MySQL CURTIME() Function

Concept visual

MySQL CURTIME() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return current time:

SELECT CURTIME();

Definition and Usage

The CURTIME() 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

CURRENT_TIME() function.

Syntax

Curtime()

Technical Details

Works in:

From MySQL 4.0

More Examples

Example

Return current time + 1:

SELECT CURTIME() + 1;

MySQL CURTIME() Function

Concept visual

MySQL CURTIME() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return current time:

SELECT CURTIME();

Definition and Usage

The CURTIME() 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

CURRENT_TIME() function.

Syntax

Curtime()

Technical Details

Works in:

From MySQL 4.0

More Examples

Example

Return current time + 1:

SELECT CURTIME() + 1;

MySQL CURTIME() Function

MySQL CURTIME() Function

Example

Return current time:

Definition and Usage

Note:

The time is returned as

Note:

This function equals the

Syntax

Curtime()

Technical Details

Works in:

More Examples

Example

Return current time + 1:

Previous

Next

MySQL CURTIME() Function

MySQL CURTIME() Function

Example

Return current time:

Definition and Usage

Note:

The time is returned as

Note:

This function equals the

Syntax

Curtime()

Technical Details

Works in:

More Examples

Example

Return current time + 1:

Previous

Next