Date and Time format in SQL

                               
                                                                                1.Date and Time format in SQL

Formate	Query	Sample
1	select convert(varchar,getdate(),1)	12/30/08
2	select convert(varchar,getdate(),2)	08.12.30
3	select convert(varchar,getdate(),3)	30/12/08
4	select convert(varchar,getdate(),4)	30.12.08
5	select convert(varchar,getdate(),5)	30-12-08
6	select convert(varchar,getdate(),6)	30 Dec 08
7	select convert(varchar,getdate(),7)	Dec 30 08
10	select convert(varchar,getdate(),10)	12-30-08
11	select convert(varchar,getdate(),11)	08/12/30
12	select convert(varchar,getdate(),12)	08 12 30
23	select convert(varchar,getdate(),23)	2008-12-30
101	select convert(varchar,getdate(),101)	12/30/2008
102	select convert(varchar,getdate(),102)	2008.12.30
103	select convert(varchar,getdate(),103)	30/12/2008
104	select convert(varchar,getdate(),104)	30.12.2008
105	select convert(varchar,getdate(),105)	30-12-2008
106	select convert(varchar,getdate(),106)	30 Dec 2008
107	select convert(varchar,getdate(),107)	Dec 30 2008
110	select convert(varchar,getdate(),110)	12/30/2008
111	select convert(varchar,getdate(),111)	2008/12/30
112	select convert(varchar,getdate(),112)	2008 12 30

Time only format:-

In SQL have some time only format lets see what are time format are there :-

                                                         1.SQL Language Element

SQL Language Element

1. Identifiers

                      Names of database objects such as tables,views,columns,rows etc.    

      2. Datatypes      

                     
                      Define the type of data that is contain by columns.

      3.Constants

                      Symbols that represent specific data type.

      4.Operators

                      Perform arithmetic,comparison and logical operations.

      5.Function

                      There are two types of functions
                               1.Built-in function
                               2. User define  function

          1.Built-in Function

                                     Built-in  function is perform specific operations.in sql have only built-in                                               function.

          2.User define function 

                                     In this function user can create there own function but to create own function                                       they have some rules.

        6.clauses

                     Constituent component of statement and queries.
                      Example:- var clause

        7.Expression

                           Produce scalar values or tables containing of column and row of data.

        8. Queries

                       Retrieve the data based on specific criteria this is an important element of SQL.

        9.Statement

                          create database ABC
                     
                          create     :- SQL command
                          Database:-Database Keyword
                          ABC      :- User define object_name