EULANDA® ERP System Head Start thru Technology

cnf_DatumKurz (SQL API)

Back | Level back

The time sets to zero to a SQL date. This date value is then simpler on equality with other date values, which likewise use this function to compare.

Syntax

cnf_DateShort @Date

Argument

@Date Datetime

The handed over date is converted in such a way by the function that the time values are set to "0".

Example

SELECT GetDate()

Output:

 COLUMN1 
---------- 
2002-02-03 13:26:44.723


However the function was resulted in cnf_DatumKurz:

SELECT dbo.DatumKurz(GetDate())

Output:

 COLUMN1 
---------- 
2002-02-03 00:00:00.000

©Eulanda Software GmbH Made in Germany, 1989-2010. All rights reserved.