Usage of convert conversion function in SQL

How to use convert:

////////////////////////////////////////////////////////////////////////////////// //////

Format:

CONVERT (Data_type,expression[,style])

Description

This style is generally in the type of time (datetime,smalldatetime) and String type (Nchar,nvarchar,char,varchar)

When they are converted to each other.

Example:

SELECT CONVERT (varchar), GETDATE (), () now

Result is

Now

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

09/15/2001

//////////////////////////////////////////////////////////////////////// /////////////

The style number has the following meanings when converting time

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

Style (2-bit year) | Style (4-bit year) | Input and output formats

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

- | 0 or 100 | Mon dd yyyy hh:miam (or PM)

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

1 | 101 | Mm/dd/yy

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

2 | 102 | Yy-mm-dd

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

3 | 103 | Dd/mm/yy

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

4 | 104 | Dd-mm-yy

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

5 | 105 | Dd-mm-yy

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