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:

Comments

Post a Comment

Popular posts from this blog

What's Virtual DOM?

There’s no big difference between the regular DOM and the virtual DOM. It’s better to think of the virtual DOM as React’s local and simplified copy of the HTML DOM. It allows React to do its computations within this abstract world and skip the real DOM operations, often slow and browser-specific. Real DOM operations are really really expensive. The Virtual DOM is an abstraction of the HTML DOM. It is lightweight and detached from the browser-specific implementation details.  One thing you should remember that the DOM itself was already an abstraction. So, Virtual DOM is an abstraction of an abstraction. :)
Post a Comment
Read more

ASP.NET Dynamic Compilation

In ASP.NET Web Applications, When we request a page it must parse and compile the code of Web Application into one or more assemblies. When the code is compiled, it's translated into a language independent and CPU independent code, that's MSIL code. When we create an ASP.NET page, actually creating the source code for a .NET class. We are creating a new instance of the System.Web.UI.Page class.The entire contents of an ASP.NET page, including all script and HTML content, are compiled into a .NET class. When request an ASP.NET page, ASP.NET Framework checks for a .NET class that corresponds to that page. If a corresponding class does not exist, the Framework automatically compiles the page into a new class and stores the compiled class (the assembly) in the Temporary ASP.NET Files folder. The Temporary ASP.NET files folder located at : \WINDOWS\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files The next time anyone requests the same page in the future, the page is not co...
Post a Comment
Read more