ToTime Function

  • Updated

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

Syntax 1

 

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

 

ToTime(hour)

 

 

Arguments:

 

 

 

hour

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

Syntax 2

 

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

 

ToTime(expression)

 

 

Arguments:

 

 

 

expression

Expression - A DateTime expression to convert.

Syntax 3

 

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

 

ToTime(hour, minute)

 

 

Arguments:

 

 

 

hour

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

 

 

minute

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

Syntax 4

 

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

 

ToTime(expression, minute)

 

 

Arguments:

 

 

 

expression

Expression - A DateTime expression to convert.

 

 

minute

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

Syntax 5

 

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

 

ToTime(hour, minute, second)

 

 

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

 

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

 

ToTime(expression, minute, second)

 

 

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

 

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

 

ToTime(hour, minute, second, millisecond)

 

 

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

 

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

 

ToTime(expression, minute, second, millisecond)

 

 

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".

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.