SQL•SQL References

MS Access Time() Function

Concept visual

MS Access Time() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return the current system time:

SELECT CustomerName,

Time() AS CurrentTime

FROM Customers;

Definition and Usage

The Time() function returns the current system time.

Syntax

Time()

Parameter Values

None.

Technical Details

Works in:

From Access 2000

MS Access Time() Function

Concept visual

MS Access Time() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return the current system time:

SELECT CustomerName,

Time() AS CurrentTime

FROM Customers;

Definition and Usage

The Time() function returns the current system time.

Syntax

Time()

Parameter Values

None.

MS Access Time() Function

MS Access Time() Function

Example

Return the current system time:

Time() AS CurrentTime

Definition and Usage

Syntax

Time()

Parameter Values

Technical Details

Works in:

From Access 2000

Previous

Next

MS Access Time() Function

MS Access Time() Function

Example

Return the current system time:

Time() AS CurrentTime

Definition and Usage

Syntax

Time()

Parameter Values

Technical Details

Works in:

From Access 2000

Previous

Next