FLOOR function [Numeric]  GROUPING function [Aggregate]

Chapter 5: SQL Functions

GETDATE function [Date and time]

Function

Returns the current date and time.

Syntax

GETDATE ()

Example

The following statement returns the system date and time.

SELECT GETDATE( ) FROM iq_dummy

Usage

GETDATE is a Transact-SQL compatible data manipulation function.

Standards and compatibility




Copyright © 2006. Sybase Inc. All rights reserved. GROUPING function [Aggregate]

View this document as PDF