Facebook Twitter RSS
banner

Latest News

DATETIME FORMATS IN SQL SERVER


HOW TO SET CURRENT DATETIME WITH DIFFERENT DATETIME FORMATS IN SQL SERVER.

Suppose the current date time is :
SELECT GETDATE()  - "2018-11-11 16:53:13.617"

And now we are converting the current date into different formats. These are as belows:
SELECT CONVERT(VARCHAR(10),GETDATE(),101) AS DATE1 = "11/11/2018"
SELECT CONVERT(VARCHAR(10),GETDATE(),102) AS DATE2 = "2018.11.11"
SELECT CONVERT(VARCHAR(10),GETDATE(),103) AS DATE3 = "11/11/2018"
SELECT CONVERT(VARCHAR(10),GETDATE(),104) AS DATE4 = "11.11.2018"
SELECT CONVERT(VARCHAR(10),GETDATE(),105) AS DATE5 = "11-11-2018"
SELECT CONVERT(VARCHAR(11),GETDATE(),106) AS DATE6 = "11 Nov 2018"
SELECT CONVERT(VARCHAR(12),GETDATE(),107) AS DATE7 = "Nov 11, 2018"
SELECT CONVERT(VARCHAR(12),GETDATE(),108) AS DATE8 = "16:53:13"
SELECT CONVERT(VARCHAR(11),GETDATE(),109) AS DATE9 = "Nov 11 2018"
SELECT CONVERT(VARCHAR(10),GETDATE(),110) AS DATE10 = "11-11-2018"
SELECT CONVERT(VARCHAR(10),GETDATE(),111) AS DATE11 = "2018/11/11"
SELECT CONVERT(VARCHAR(10),GETDATE(),112) AS DATE12 = "20181111"
SELECT CONVERT(VARCHAR(11),GETDATE(),113) AS DATE13 = "11 Nov 2018"
SELECT CONVERT(VARCHAR(11),GETDATE(),114) AS DATE14 = "16:53:13:61"

Please see the below screenshot for the clarifications.



  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

  - - - - - - - - - - - - - - - - - - - - - - - - Cheers, Happy to Help! - - - - - - - - - - - - - - - - - - - - - - - - - - -
Posted by Unknown , 10:24 0

Adding two numbers in javascript

Addition of Two Numbers in Asp.Net.

 

  <html>
  <head>
  <title>Add two numbers </title>
  </head>
  <body>
  <form id="form1" runat="server"><br />
  <div style="width:400px; height:150px;">
  <div style="width:120px; height:30px; float:left">First Number</div>
  <div style="width:180px; height:30px; float:left">
  <asp:TextBox ID="txtFirstNumber" runat="server"></asp:TextBox> </div>
   <br /><br />
   <div style="width:120px; height:30px;; float:left">Second Number</div>
   <div style="width:180px; height:30px;  float:left">
   <asp:TextBox ID="txtSecondNumber" runat="server"></asp:TextBox> </div>
    <br /><br />
   <div style="width:120px; height:30px;  float:left">Result</div>
   <div style="width:180px; height:30px; float:left">
   <asp:TextBox ID="txtResult" runat="server"></asp:TextBox> </div>
    <br /><br />
    <div style="width:120px; height:30px;  float:left">
   <asp:Button ID="btnAdd" Width="110px" Text="Add" runat="server" OnClick="btnAdd_Click" />          </div>
 <div style="width:180px; height:30px;  float:left"> 
 <asp:Button ID="btnCancel" Width="110px" Text="Cancel" runat="server" /> </div>
 </div>
  </form>
</body>
</html>


Design: 
Posted by Unknown , 06:22 0

Return Even and Odd Records by Date in SQL

     
             The Syntax is:

                              update table_name set column_name=GETDATE()


                           Above query will return all records with same current date.
                                   

             The Syntax is:

             update table_name set column_name=dateadd(day,1,GETDATE())where id_Student%2=0
               
            The Result will be:
                                       

     Above query will return odd records by current date and even records by next date.
Posted by Unknown , 10:34 0
Subscribe to: Posts (Atom)