Jan 29, 2009
Jan 21, 2009
How to Combine Date & Time in SQL
/*
=================================================================
== PROCEDURE: COMBINE_DTM
==
== PURPOSE:Combines a date and time into a datetime result
==
== CREATED:Friday, October 3, 2008 @ 1:24:00 AM
==
== TYPE:APP
=================================================================*/
CREATE FUNCTION [dbo].[COMBINE_DTM] (
@inDATE_DTM AS datetime,
@inTIME_DTM AS datetime
) RETURNS datetime
AS
BEGIN
RETURN
CAST((ROUND(CAST(@inDATE_DTM AS float), 0, 1) ) AS float) +
(CAST(@inTIME_DTM AS float) - (ROUND(CAST(@inTIME_DTM AS float), 0, 1)) + .00000001)
END
use this links to original links
http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/ee161d81-8f04-4328-b2a8-a32f95c30b29/
or
http://blogs.msdn.com/patrickgallucci/archive/2007/11/18/sql-server-function-to-merge-a-date-with-a-time.aspx
=================================================================
== PROCEDURE: COMBINE_DTM
==
== PURPOSE:
==
== CREATED:
==
== TYPE:
=================================================================*/
CREATE FUNCTION [dbo].[COMBINE_DTM] (
@inDATE_DTM AS datetime,
@inTIME_DTM AS datetime
) RETURNS datetime
AS
BEGIN
RETURN
CAST((ROUND(CAST(@inDATE_DTM AS float), 0, 1) ) AS float) +
(CAST(@inTIME_DTM AS float) - (ROUND(CAST(@inTIME_DTM AS float), 0, 1)) + .00000001)
END
use this links to original links
http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/ee161d81-8f04-4328-b2a8-a32f95c30b29/
or
http://blogs.msdn.com/patrickgallucci/archive/2007/11/18/sql-server-function-to-merge-a-date-with-a-time.aspx
Dec 17, 2008
How to get week name in sql:sql/sql2005
CREATE FUNCTION dbo.DayOfWeek_fn(@dtDate DATETIME)
RETURNS VARCHAR(10)
AS
BEGIN
DECLARE @rtDayofWeek VARCHAR(10)
DECLARE @weekDay INT
-- Here I have subtracted 7 For keeping Sunday as the First day
-- like wise for Monday we need to subtract 2 and so on
SET @weekDay = ((DATEPART(dw,@dtDate)+@@DATEFIRST-7)%7)
SELECT @rtDayofWeek = CASE @weekDay
WHEN 1 THEN 'Sunday'
WHEN 2 THEN 'Monday'
WHEN 3 THEN 'Tuesday'
WHEN 4 THEN 'Wednesday'
WHEN 5 THEN 'Thursday'
WHEN 6 THEN 'Friday'
WHEN 7 THEN 'Saturday'
END
RETURN (@rtDayofWeek)
END
GO
RETURNS VARCHAR(10)
AS
BEGIN
DECLARE @rtDayofWeek VARCHAR(10)
DECLARE @weekDay INT
-- Here I have subtracted 7 For keeping Sunday as the First day
-- like wise for Monday we need to subtract 2 and so on
SET @weekDay = ((DATEPART(dw,@dtDate)+@@DATEFIRST-7)%7)
SELECT @rtDayofWeek = CASE @weekDay
WHEN 1 THEN 'Sunday'
WHEN 2 THEN 'Monday'
WHEN 3 THEN 'Tuesday'
WHEN 4 THEN 'Wednesday'
WHEN 5 THEN 'Thursday'
WHEN 6 THEN 'Friday'
WHEN 7 THEN 'Saturday'
END
RETURN (@rtDayofWeek)
END
GO
Dec 4, 2008
Nov 4, 2008
Removing Additional White-Spaces in Sentence (C#) « N Rao Lakkakula’s Blog
Removing Additional White-Spaces in Sentence (C#) « N Rao Lakkakula’s Blog: "System.Text.RegularExpressions.Regex.Replace(input, @”\s+”, ” “);"
Subscribe to:
Posts (Atom)