Varieties of dates available in sql server :-


Declare @Date datetime

SET @Date = '1/1/2011'

WHILE @Date < '1/1/2012'
BEGIN
SELECT
CONVERT(VARCHAR(8), @Date, 112) date1, @Date fulldate, YEAR(@Date) years,
DATEPART(qq, @Date) quater, DATEPART(ww, @Date) yearweeks, DATENAME(dw, @Date) dayname,
DATEPART(dd, @Date) dateno, DATENAME(mm, @Date) monthnam, DATEPART(dy,@Date) daycnt,
DATENAME(mm, @Date) + ' ' + CAST(DATEPART(dd, @Date) AS CHAR(2)) + ',' + CAST(DATEPART(yy, @Date) AS CHAR(4)) [mm dd,yyyy],
CONVERT(VARCHAR(10), @Date, 101) normaldate,
DATEPART(dw, @Date) ,
DATEPART(mm, @Date) dateno

SET @Date = DATEADD(dd, 1, @Date)
END

Comments

Post a Comment

Popular posts from this blog

Export gridview into excel pdf csv   http://www.aspsnippets.com/ Articles/Print-functionality- in-ASP.Net- GridView -control. aspx  http://www.aspsnippets.com/ Articles/Export- GridView -To- Word-Excel-PDF-CSV-Formats-in- ASP.Net.aspx
Read more
How to insert multiple rows from c# table to sql database table:- Frontend:   <asp:Button ID="Button2" runat="server" Text="Create Table"             onclick="Button2_Click" /> <asp:GridView ID="gveg" runat="server">         </asp:GridView> Backend C#:  protected void Button2_Click(object sender, EventArgs e)     {         //         // Here we create a DataTable with four columns.         //                 DataTable temptable = new DataTable();         temptable.Columns.Add("ProductID", typeof(string));         temptable.Columns.Add("RelatedProductID", typeof(string));       ...
Read more