اعطاء نتائج خاطئة حول Am Pm

Create Function dbo.Get_Date_Part

(

@Original_Date DateTime

)

RETURNS datetime

/*

this function will return the date pare only, for example,

input date : 01/30/2006 12:06:00 AM

output date: 01/30/2006 00:00:00

*/

begin

DECLARE @V datetime

set @V=CONVERT (DATETIME, (CONVERT (char(10), @Original_Date, 101)), 101)

RETURN @V

end

CREATE PROCEDURE Get_HRS_Time_Attendance_Of_Dates

@From_Date datetime,

@To_Date datetime

AS

SELECT

Record_No,

Emp_No,

Login_Date,

LogOut_Date,

Attendance_Description,

Approving,

Absent

FROM

HRS_Time_Attendance

where

Login_Date between @From_Date And @To_Date

GO