How get current date in SQL server 2000

Answer Posted / gautam k panjikar

getdate()

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I open port 1433?

530


How to create and drop temp table in sql server?

591


can an automatic recovery be initiated by a user? : Sql server administration

521


what are the disadvantages of cursors? : Sql server database administration

496


What is format parameter in ssrs?

109






What is coalesce in sql server?

539


What are the restraints imposed on the table design by a merge replication?

570


What is a database table?

525


Which sql server is best?

518


What is a dataset and what are the different types of datasets?

93


can you implement data mining in SSRS?

113


How to Sync Two SQL Azure Databases?

101


What is dbcc? Give few examples.

582


define and explain the differences between clustered and non-clustered indexes.

601


Do you know what are the reporting services components?

535