Posted by: R Manimaran | February 14, 2007

Get First Day of Month in Sql server 2000

CREATE FUNCTION [dbo].[ufn_GetFirstDayOfMonth] ( @pInputDate    DATETIME ) RETURNS DATETIME BEGIN      RETURN CAST(CAST(YEAR(@pInputDate) AS VARCHAR(4)) + '/' +                  CAST(MONTH(@pInputDate) AS VARCHAR(2)) + '/01' AS DATETIME)  END GO
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: