Skip to main content

SQL Server: How do get only Date from Datetime?

Hi,
In real time business applications, we'll meet some scenarios like this. From our UI we'll send the Date time to the SQL Server to calculate the exact number of days different between today and the date passing by us.
Actually the GETDATE() function of SQL Server gives the Server's Date time in this format: 2011-01-26 11:43:13.397
The Date time sending from client UI will be like this: 2011-01-02 12:00:00.000
When we try to calculate the exact number of days different between these it'll take time too. This may be give wrong answer. In this situation we can ommit the time part of the both dates.
Here I wrote one SQL Server User Defined Function to achieve this. 
CREATE FUNCTION [dbo].[UFN_GetExactDate] (@InputDate DATETIME)
RETURNS DATETIME
BEGIN
DECLARE @OutputDate DATETIME
SELECT @OutputDate= CAST(CONVERT(VARCHAR(25),@InputDate,101) AS DATETIME)
RETURN @OutputDate
END
We can use this UDF in our Stored procedures like this: SELECT [dbo].[UFN_GetExactDate](GETDATE())
This will give result like this: 2011-01-26 00:00:00.000 
Hope this helps!

Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

Javascript - Unanswered questions - Part 1

What is Event delegation? Event delegation is Javascript as it relates to the DOM. It basically means that if you attach an event listener to a DOM element that listener is not only firing on that DOM element. It's actually firing on every children in that. So, for instance if you have a navigation and so you've got an unordered list you've got list items and then you've got anchor tags inside that navigation what you have. If you add an event listener to the ul element in essence you're actually adding event listener to all of the children as well. In short, JS event listeners fir not only on a single DOM element but on all its descendants. What is Event Bubbling? It's actually inverse of Event delegation. Also known as propagation, events on an DOM element will bubble up and also fire on all parents.  What's the difference between "target" and "currentTarget"? target is the actual element that triggered the event for example clicked, wh...
Post a Comment
Read more

Multiplication Table in SQL Server

Multiplication Table in SQL Server This query gives the multiplication table from 1 to 10. DECLARE @A INT,                   @B INT,                   @C INT,                   @D VARCHAR (100)                   SELECT @A=1                  PRINT ' MULTIPLICATION TABLE 1-10' /****************************************/ /* Created By : Loganathan V */ /* Created On: 20-Sep-2010, Monday */ /* Purpose : Multiplication Table */ /* How to : RUN THE QUERY */ /****************************************/ WHILE (@A<=10) BEGIN         ...
5 comments
Read more

Large Volume of Dataset Transfer from WCF to Silverlight

Most of the times the developers, architects have the problem to retrieve large volume of data from WCF Service to Silverlight client applications. It’s a big head ache for developers. But it’s not up to that much problematic one. We can solve this problem by changing some property’s values in Web.config of WCF Service host, Silverlight application’s ServiceReference.clientconfig and Silverlight XAP hosted ASP.Net Applications. Here I’m going to explain the Web.config changes we need to retrieve large volume of data from WCF Service and also uploading large size of files to the Server. Last week, I was trying to figure out why my WCF service call always threw the generic NotFound exception when trying to retrieve large datasets. Even though, I set buffer limits to 2147483647 (int.MaxValue) in the Silverlight ServiceReferences.ClientConfig file and WCF Service configuration Section under web.config the problem was persisting. I tried so many things from Data Access Layer and UI. Finall...
5 comments
Read more