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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
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 
Alternative way to DetDate() function?
 Question Submitted By :: Mohanakrishnan A.c
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Alternative way to DetDate() function?
Answer
# 1		 
First you Clearly Learn.It's GetDATE() function, Not DetDate
() function.

In SQL Server 2000 Query :
--------------------------

Select GetDate()

Output:
------
2008-01-22 17:37:20.280

Alternate to GetDate() function:
--------------------------------

Select GetUTCDate()

Output:
-------
2008-01-22 17:37:20.280

GetUTCDATE() means Greenwhich Mean Time of Current Date 
Time.
 
Is This Answer Correct ?    0 Yes 0 No
Selvaraj.v
 
  Re: Alternative way to DetDate() function?
Answer
# 2		 
SELECT   CURRENT_TIMESTAMP

(just searched in Help of SQL Server 2005)
 
Is This Answer Correct ?    2 Yes 1 No
Vadivu
 
 
 
  Re: Alternative way to DetDate() function?
Answer
# 3		 
SELECT current_date(for currentdate only)
SELECT NOW()
 
Is This Answer Correct ?    0 Yes 0 No
Brahma Prakash
 
  Re: Alternative way to DetDate() function?
Answer
# 4		 
Hi Selvaraj,

It is clearly seems to be a spelling mistake.so,stop pointing out such silly mistakes.Any one can knows that he is asking about getdate()
 
Is This Answer Correct ?    0 Yes 0 No
Rajesh.a
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is a view? is View updatable? IBM11
There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"  1
What are the four main query statements?  3
what purpose does OPENXML clause have in sql server stored procedure?  1
how can we use a composite key for two tables and how can we represent it BoA1
PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs. APX2
can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?  1
How will u get 5 years back record?  4
What is a Linked Server?  1
What does the INSTEAD OF trigger do?  3
What is a function? Give some example?  2
What is the difference between login and a user? TCS7
What are the different types of joins and what does each do?  2
HOW TO RENAME A COLUMN NAME  2
create index a on employee(dno) In this,which index was created?  2
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?  2
Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records. 247Customer3
How do you find the error, how can you know the number of rows effected by last SQL statement?  2
What is the datatype returned by count(*) Asian-CERC18
what is the output for this query select * from employee where 1=1;  4
 
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