Skip to main content

SQL Server CONVERT() Function

SQL Server CONVERT() Function

The CONVERT() function is a general function that converts an expression of one data type to another.
The CONVERT() function can be used to display date/time data in different formats.

Syntax

CONVERT(data_type(length),expression,style)

Example

The following script uses the CONVERT() function to display different formats. We will use the GETDATE() function to get the current date/time:
CONVERT(VARCHAR(19),GETDATE())
CONVERT(VARCHAR(10),GETDATE(),10)
CONVERT(VARCHAR(10),GETDATE(),110)
CONVERT(VARCHAR(11),GETDATE(),6)
CONVERT(VARCHAR(11),GETDATE(),106)
CONVERT(VARCHAR(24),GETDATE(),113)
The result would look something like this:
Nov 04 2011 11:45 PM
11-04-11
11-04-2011
04 Nov 11
04 Nov 2011
04 Nov 2011 11:45:34:243

Comments

Post a Comment

Popular posts from this blog

MIME Types list

Multipurpose Internet Mail Extensions (MIME) is an Internet standard that extends the format of email to support: Text in character sets other than ASCII Non-text attachments: audio, video, images, application programs etc. Message bodies with multiple parts Header information in non-ASCII character sets    MIME Types list   Suffixes Mime .3dm x-world/x-3dmf .3dmf x-world/x-3dmf .a application/octet-stream .aab application/x-authorware-bin .aam application/x-authorware-map .aas application/x-authorware-seg .abc text/vnd.abc .acgi text/html .afl video/animaflex .ai application/postscript .aif audio/aiff .aif audio/x-aiff .aifc audio/aiff .aifc audio/x-aiff .aiff audio/aiff .aiff audio/x-aiff .aim application/x-aim .aip text/x-audiosoft-intra .ani application/x-navi-animation .aos application/x-nokia-9000-communicator-add-on-software .aps application/mime .arc ap...
4 comments
Read more

How to put counter of remaining charector of text in textbox

How to put counter for char remaining in textbox Html <asp:TextBox runat="server" ID="TxtBody" CssClass="form-control" TextMode="MultiLine" Rows="5" placeholder="Body" MaxLength="159" ></asp:TextBox> <div id="Textremaining"></div> Javascript $(document).ready(function() {     var maxChar = 159;     $('#Textremaining').html(maxChar + ' remaining');     $('#<%=TxtBody.ClientID%>').keyup(function() {         var length = $('#<%=TxtBody.ClientID%>').val().length;         var remaining = maxChar - length;         $('#Textremaining').html(remaining  + ' characters remaining');     }); });
3 comments
Read more

Check your content

http://www.copyscape.com want to check your content is posted in other site or in blog. check in from this site. this site list out the content is posted which places. very useful for bloggers.
Post a Comment
Read more