EULANDA® ERP System Head Start thru Technology

cnf_StartOfTheWeek (SQL API)

Back | Level back

Determines the first day of the week, in which the indicated dates lies.

Syntax

SELECT dbo.cnf_StartOfTheWeek(@Date)
SET @d = dbo.cnf_StartOfTheWeek(@Date)

Parameter

@date datetime

The basis date

Return value datetime

determined date

A. simple example

Comparison of GETDATE() and cnf_StartOfTheWeek

T-SQL

SELECT 
  [Week beginning] = dbo.cnf_StartOfTheWeek(GETDATE()), 
  [Now] = GETDATE() 

Output:

Week beginning             Now
2005-05-23 00:00:00.000  2005-05-27 15:58:57.233

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