today date in storeprocedure

Question

4.00/5 (1 vote)

See more:

how to get today date in storeprocedure coding.
when using command text this will done using datetime.Today().
but how to get today date in storeprocedure?

i have select checktime using query ..

select  top 1 @CheckType=CheckType,@CheckTime=CheckTime,@Userid=Userid,@Logid=Logid from Checkinout order by logid desc

now if checktime is today date then update record .for this i have do ....

if(@CheckTime = getdate())
	begin
UPDATE       Biometrics
SET                [Name] = @Name,[Date]=InTime ,Group_Id = @Groupid, OutTime = @CheckTime, Duration=DATEDIFF(mi, InTime , @CheckTime)  where  id=@id
	end

but my record not updated.what is problem?

Posted 30-Jan-13 2:32am

Member 9511889

Updated 30-Jan-13 2:43am

v3

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Answer 1 · 2013-01-30T02:32:00

Solution 1

In SQL you can do

SQL

SELECT GETDATE() AS TodaysDate

Posted 30-Jan-13 2:32am

ZurdoDev

Comments

Member 9511889 30-Jan-13 8:40am

i have select checktime using query ..
select top 1 @CheckType=CheckType,@CheckTime=CheckTime,@Userid=Userid,@Logid=Logid from Checkinout order by logid desc

now if checktime is today date then update record .for this i have do ....
if(@CheckTime = getdate())
begin
UPDATE Biometrics
SET [Name] = @Name,[Date]=InTime ,Group_Id = @Groupid, OutTime = @CheckTime, Duration=DATEDIFF(mi, InTime , @CheckTime) where id=@id
end
but my record not updated.what is problem?

ZurdoDev 30-Jan-13 8:49am

GetDate() includes the time so that is why @CheckTime is not working. What is in your @CheckTime?

Ksh_Sr · Answer 2 · 2013-01-30T02:49:00

Replace ur condition wid below one

SQL

if( Convert(varchar,@CheckTime,101) = Convert(varchar,getdate(),101) )
begin
UPDATE  Biometrics
SET  [Name] = @Name,[Date]=InTime ,Group_Id = @Groupid, OutTime = @CheckTime, Duration=DATEDIFF(mi, InTime , @CheckTime)  where  id=@id
    end

plz vote and accept ans if it helps u :)
if it works for u i wll explain u y ur code wsnt workin

happy coding buddy :)

today date in storeprocedure

2 solutions

Solution 1

Solution 4

Add your solution here

Preview 0

today date in storeprocedure

2 solutions

Solution 1

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us