Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

CSharp TV
Videos
Tech
Articles
Blogs
News
Forums
Books
Events

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Latest Forum Questions

How to data fetch login form to order form nane email contact number
Abhishek Jagadale3h ago0
What's the Most Overrated AI Feature?
Rom C6h ago2
How to load 5000 data in Power Apps gallery
Ismail Sayyad6h ago2
How Are AI Agents Different from Chatbots? (2026 Breakdown)
Laura Bennett7h ago4
What is full-stack data science, and how is it different from traditional data science?
tejasri7h ago3
LINQ and Lambda Expressions
Sangeetha S7h ago3
upload document on server in .net
sagar k2d ago3
How Are You Using AI Coding Agents (Claude Code, Copilot, etc.)
Sudarshan Hajare3d ago1
Error converting data type nvarchar to numeric
David Godistei3d ago2
winform task
Nandini Sonawane3d ago1
Repair MS Outlook PST file issue
Chemline Dorno5d ago2
CrystalDecisions.CrystalReports.Engine
Ramco Ramco7d ago0
Which library is primarily used for numerical computing in Python?
tejasri13d ago1
Best pattern for streaming AI responses into a Blazor Server app without flooding the SignalR circuit?
Aarti Jangid14d ago0
How Can AI Data Engineering Improve Data Quality and RAG Application Performance?
Aarti Jangid15d ago0
How to Prevent Sensitive Data Exposure in AI Workflows
Rom C15d ago0
What is RAG in Generative AI?
tejasri19d ago4
add code snippet
Priya Prajapati21d ago2
about azure app service
jahnavi charakani22d ago0
How do you handle missing values in a dataset before building a machine learning model?
tejasri26d ago3

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

How to compare whether two timings are equal or not in SQL Server

Home
Forums

How to compare whether two timings are equal or not in SQL Server

SIVA

SIVA

14yAsked Apr 6, 2012, 9:51 AM2k

Dear All,

I need to know how to compare Two timings in SQL Server

Here,

User will pass the @StatusTime as parameter for my Procedure

& i ll get the current time from my local system as follows.

Declare @CurrentTime datetime

set @CurrentTime=GetDate()

Now i need to compare these two?

Thanks in Advance

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Senthilkumar14y ago
Accepted answer
Hi Siva,

Please find the stored procedure of date comparision.

CREATE PROCEDURE Proc_CheckStatusTime
@StatusTime DATETIME
AS
BEGIN
SET NOCOUNT ON
DECLARE @StatusInputTime VARCHAR(100)
DECLARE @CurrentTime VARCHAR(100)

SET @StatusInputTime = CONVERT(VARCHAR,@StatusInputTime,101)
SET @CurrentTime = CONVERT(VARCHAR,GETDATE(),101)
IF (@CurrentTime = @StatusInputTime)
BEGIN
PRINT 'Both times are equal'
END
ELSE
BEGIN
PRINT 'Oops! Both times are not equal'
END
END

I have tested in sql server. Same you can do it from the front end.

DECLARE @dt DATETIME
SET @dt = GETDATE()
EXEC Proc_CheckStatusTime @dt
0
MuthuMari M14y ago
Hi,

The DATEDIFF() function returns the time between two dates.

pls refer this for samples

http://demiliani.com/blog/archive/2006/01/19/3384.aspx

http://www.w3schools.com/sql/func_datediff.asp

thanks.

If this post helps you, then mark as "Correct Answer"
0