How get current date in SQL server 2000

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

What is the recommended total size of your memory optimized tables?

0 Answers  


Is index a datbase objects in sql server?

2 Answers  


What is the need for indexing?

0 Answers  


Without Using Cursors , How to Select the Selected row??

3 Answers   CarrizalSoft Technologies, Wipro,


What do you understand by recursive stored procedure?

0 Answers  


How can you tell if a database object is invalid?

0 Answers   MCN Solutions,


What is the difference RDBMS and Graph Database?

0 Answers   EXL,


How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,


What is the difference between count () and rowcount ()?

0 Answers  


Indexes are updated automatically is the full-text index also updated automatically?

0 Answers  


What are policy management terms?

0 Answers  


How to find the date and time of last updated table?

6 Answers   Teledata,


Categories