Vikram Kamath

April 9, 2010

DateTime Manipulation: Continued

Filed under: SQL Server — Tags: , , , — Vikram @ 16:55

In my previous post DateTime Manipulation: Date Part or Time Part I had mentioned about how we can get the date part and time part from a given DateTime. A couple of days back I came across an article in sqlservercentral.com where another solution has been provided to get the date and time part out a given datetime using the DATEADD and DATEDIFF functions

Here is the link to the article Date Manipulation with DATEADD/DATEDIFF

Note: You may need to be logged into sqlservercentral.com to view this article

Advertisements

Create a free website or blog at WordPress.com.