Re: Format() Function in MS SQL
- From: "Stu" <stuart.ainsworth@xxxxxxxxx>
- Date: 28 Nov 2005 21:50:10 -0800
try
=CONVERT(smalldatetime,DATENAME(m, GETDATE()) + ' 1,' + DATENAME(yy,
GETDATE()))
HTH,
Stu
.
- References:
- Format() Function in MS SQL
- From: sql guy123
- Re: Format() Function in MS SQL
- From: Erland Sommarskog
- Re: Format() Function in MS SQL
- From: sql guy123
- Format() Function in MS SQL
- Prev by Date: Re: Passing DateDiff rather than Actual Dates as Parameters
- Next by Date: Re: STORED PROCEDURE - passing table name as a parameter
- Previous by thread: Re: Format() Function in MS SQL
- Next by thread: Re: Format() Function in MS SQL
- Index(es):
