GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Database  >  SQL Server

 Print  |  
Question:  What is the code to create a table having a column named DATE, which takes date in the format dd/mm/yyyy, in SQL Server2000? Or any format of date.



June 06, 2006 06:08:27 #1
 sudal2000   Member Since: May 2006    Total Comments: 2 
RE: What is the code to create a table having a column...
 

hai,

          using this query you can take as you like,

           select convert(varchar,DATE,107) from tablename

            DATE->one of the column is availabe in table which is created by you
     

 

Back To Question