Samuele E. Locatelli
17 lines
412 B
SQL
17 lines
412 B
SQL
|
|
/***********************************************************************************
|
|
* FUNCTION f_dateOnly
|
|
*
|
|
* restituisce solo la parte data di un campo datetime (ovvero a mezzanotte...)
|
|
*
|
|
***********************************************************************************/
|
|
create FUNCTION f_dateOnly
|
|
(
|
|
@dateIn DATETIME
|
|
)
|
|
RETURNS DATETIME
|
|
AS
|
|
BEGIN
|
|
RETURN dateadd(dd, -datediff(dd, @dateIn, 1), 1)
|
|
END
|