How get current date in SQL server 2000

Question Posted / ravi2514

4 Answers
6810 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 create new tables with "select ... Into" statements in ms sql server?

0 Answers

What is Service Broker in sql server 2012?

0 Answers UGC Corporation,

What is 'Join' and explain its various types.

0 Answers Genpact,

How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?

3 Answers

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 Answers

How to add code to the existing article (using improve article)?

0 Answers

What are the restrictions that views have to follow? : SQL Server Architecture

0 Answers

Explain full-text indexing?

0 Answers

What is partition in sql server?

0 Answers

Tell me what is de-normalization and what are some of the examples of it?

0 Answers

How to copy the tables, schema and views from one sql server to another?

0 Answers

What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers Infosys,

For more SQL Server Interview Questions Click Here