Different Time Format In SQL Server

-

1.Get HH:mm:ss Time Format:

    select convert(varchar(10),GETDATE(),108) as Time 
    
     Result:
          Time
          22:45:44

2.Get HH:mm:ss:mmm Time Format:

    select convert(varchar(20),GETDATE(),114) as Time 
    
     Result:
          Time
          22:45:44:887

Comments

Post a Comment

Thank You for your Comment

Popular posts from this blog

Unable to perform operation on the item is locked in workspace

-
Image
Hi,  I am getting this issue last week. so I Fixed. I Will share the Solution. Some files struggle with another person's systems workspace. then you can't able to check-in in your TFS. The particular file was blocked or Locked in another person system so easily remove that person Workspace issue will be solved you can check-in your file into the TFS. tf workspace /delete /server:http://192.168.1.50:8080/tfs/projectname NCS-P01-001_2;R****h
Read more

Insecure cookie setting: missing Secure flag

-
  Issue Description: Insecure Cookie Setting - Missing Secure Flag Explanation: The "Secure" flag is an attribute that can be set for cookies in web applications. When the Secure flag is enabled for a cookie, the cookie is only transmitted over HTTPS connections, ensuring that it is sent securely over an encrypted channel. This is crucial for security because it helps prevent the exposure of sensitive information contained in cookies, such as session tokens or authentication credentials, to potential attackers. When the Secure flag is missing from a cookie, it means that the cookie can be sent over both secure (HTTPS) and non-secure (HTTP) connections. This can pose a significant security risk, as sensitive information could be exposed if the cookie is transmitted over an insecure connection. Impact: The impact of missing the Secure flag on a cookie depends on the context in which the cookie is used. Here are some potential risks: Session Hijacking: If an attacker can inter...
Read more

Display Canvasjs Line Chart using Data from Database

-
Image
Aspx Page: <% @ Page Language ="C#" AutoEventWireup ="true" CodeBehind ="Canvasjs.aspx.cs" Inherits ="BloggerCont.Canvasjs" %> < html xmlns ="http://www.w3.org/1999/xhtml"> < head runat ="server">     < script src ="jquery-1.7.1.js" type ="text/javascript"></ script >     < script src ="canvasjs.min.js" type ="text/javascript"></ script >     < script type ="text/javascript">         $(document).ready( function () {             Disp();         });         function Disp() {             var dataPts = [];             var var1;         ...
Read more