How get current date in SQL server 2000

Question Posted / ravi2514

4 Answers
6849 Views
Cap Gemini, Polaris, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How get current date in SQL server 2000..

Answer / gautam k panjikar

getdate()

Is This Answer Correct ?

6 Yes

2 No

How get current date in SQL server 2000..

Answer / rajkumar v

select convert(varchar,getdate(),105)

Is This Answer Correct ?

3 Yes

0 No

How get current date in SQL server 2000..

Answer / anto

select getdate()

Is This Answer Correct ?

2 Yes

1 No

How get current date in SQL server 2000..

Answer / mt

select getdate();

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More SQL Server Interview Questions

how to dispaly a particular row details from a given table

2 Answers

What is the use of =,==,=== operators?

0 Answers

What is difference between aggregate and analytic function?

0 Answers

Why normalization is used?

0 Answers

Please illustrate physical database architecture? : SQL Server Architecture

0 Answers

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 Answers

What is a transaction and what are ACID properties?

3 Answers

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

2 Answers

What is “asynchronous” communication in sql server service broker?

0 Answers

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers

What are the acid properties?

0 Answers

How to modify an existing user defined function?

0 Answers

For more SQL Server Interview Questions Click Here