Skip to main content



ToTime Function

The ToTime function returns a time based on source parameters. The date portion is 1/2/0001.

Syntax 1​

ToTime(hour)

The ToTime function returns a time based on source parameters. The date portion is 1/2/0001.

Arguments​

hour Integer - Hour number, in the range 0-23.

Syntax 2​

ToTime(expression)

The ToTime function returns a time based on source parameters. The date portion is 1/2/0001.

Arguments​

expression Expression - A DateTime expression to convert.

Syntax 3​

ToTime(hour, minute)

The ToTime function returns a time based on source parameters. The date portion is 1/2/0001.

Arguments​

hour Integer - Hour number, in the range 0-23.

minute Integer - Minute number, in the range 0-59.

Syntax 4​

ToTime(expression, minute)

The ToTime function returns a time based on source parameters. The date portion is 1/2/0001.

Arguments​

expression Expression - A DateTime expression to convert.

minute Integer - Minute number, in the range 0-59.

Syntax 5

ToTime(hour, minute, second)

The ToTime function returns a time based on source parameters. The date portion is 1/2/0001.

Arguments​

hour Integer - Hour number, in the range 0-23.

minute Integer - Minute number, in the range 0-59.

second Integer - Second number, in the range 0-59.

Syntax 6

ToTime(expression, minute, second)

The ToTime function returns a time based on source parameters. The date portion is 1/2/0001.

Arguments​

expression Expression - A DateTime expression to convert.

minute Integer - Minute number, in the range 0-59.

second Integer - Second number, in the range 0-59.

Syntax 7

ToTime(hour, minute, second, millisecond)

The ToTime function returns a time based on source parameters. The date portion is 1/2/0001.

Arguments​

hour Integer - Hour number, in the range 0-23.

minute Integer - Minute number, in the range 0-59.

second Integer - Second number, in the range 0-59.

millisecond Integer - Millisecond number, in the range 0-999.

Syntax 8

ToTime(expression, minute, second, millisecond)

The ToTime function returns a time based on source parameters. The date portion is 1/2/0001.

Arguments​

expression Expression - A DateTime expression to convert.

minute Integer - Minute number, in the range 0-59.

second Integer - Second number, in the range 0-59.

millisecond Integer - Millisecond number, in the range 0-999.

Remarks​

Example:

ToTime("#6/14/2005 06:21:32#"); // returns 6:21:32 AM

Example:

ToTime(23, 59, 59, 476); // returns "T23:59:59:476"