BOL Example

The following statement returns 1:

SELECT datediff( hour, '4:00AM', '5:50AM' )

The following statement returns 102:

SELECT datediff( month, '1987/05/02', '1995/11/15' )

The following statement returns 0:

SELECT datediff( day, '00:00', '23:59' )

The following statement returns 4:

SELECT datediff( day,
'1999/07/19 00:00',
'1999/07/23 23:59' )

The following statement returns 0:

SELECT datediff( month, '1999/07/19', '1999/07/23' )

The following statement returns 1:

SELECT datediff( month, '1999/07/19', '1999/08/23' )

P.S. скачайте документацию и указывайте ASA, ASE...