EULANDA® ERP System Head Start thru Technology

cnf_KW (SQL API)

Back | Level back

Converts a SQL Date value into the usual calendar week.

Syntax

cnf_KW @Date

Argumente

@Date Datetime

SQL-Date value are converted over this function into a calendar week. The SQL server contains also a function for the calendar week, this corresponds however not to the calendar weeks usual in Europe. Over this function you can now spent these.

Example

SELECT 
  dbo.cnf_KW('05.02.2002')

Output:

 COLUMN1 
---------- 
6 

(1 Line effected)

Commands finally succesfully

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