| Author: Chandrasekhar 19 May 2008 | Member Level: Silver Points : 2 |
DECLARE @mydate DATETIME
SELECT @mydate = getdate()
SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@mydate)-1),@mydate),101) AS Date_Value
|
| Author: Nirupa Rani Acharya 27 Jul 2008 | Member Level: Bronze Points : 0 |
thanks.
|
| Author: amit chaudhary 22 Aug 2008 | Member Level: Silver Points : 1 |
This is the code for calculating first day of the month:-
Select DateAdd(Month,DateDiff(Month,0, GETDATE()),0)
|