ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
How can u convert the Date to String?
 Question Submitted By :: Bhaskar
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How can u convert the Date to String?
Answer
# 1
select convert(varchar,columnname,101) from tablename
 
Is This Answer Correct ?    4 Yes 0 No
Prasad
 
  Re: How can u convert the Date to String?
Answer
# 2
select convert(varchar(20),getdate())
 
Is This Answer Correct ?    2 Yes 3 No
Deepak Rohilla
 
 
 
  Re: How can u convert the Date to String?
Answer
# 3
Select convert(varchar(20),getdate()) As Date
 
Is This Answer Correct ?    2 Yes 0 No
Sivakumar
 
  Re: How can u convert the Date to String?
Answer
# 4
select cast(getdate() as varchar)

select convert(varchar,getdate(),101)-mm/dd/yyyy
select convert(varchar,getdate(),102)-yy.mm.dd
select convert(varchar,getdate(),106)-ddmmyy
select convert(varchar,getdate(),108)-hh:mm:ss

etc.
 
Is This Answer Correct ?    9 Yes 1 No
Rajesh Ranjan
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? HCL1
WHAT OPERATOR PERFORMS PATTERN MATCHING? CTS2
What is a stored procedure?  3
wht is normalization?can u explain me in detail? TCS6
How the data stores in a page?  1
what are the joins,primary key,foriegn key, candidate key, super key and expain them? Polaris2
what is the difference between sql query and google query? TCS7
Which virtual table does a trigger use?  3
how to connect sybase to sql server 2005?. ABC1
plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005  3
plz send every query in sql server2000 Infosys1
In clustered and non clustered indexes which one is faster while executing a query ?  1
WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX L&T2
How to retrieve data from log files in SQL SERVER ?????  1
How to Execute an Operating System Command From Within SQL Server ?  2
how to know description of a table in sqlserver 2000  7
what is difference between primary key and Unique  8
What is the difference between a Application Server and a Database Oracle2
What is the difference between a stored procedure and a user defined function in sql server? Millennium2
How do you find the error, how can you know the number of rows effected by last SQL statement?  1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com