select convert(varchar,getdate(),105)

How get current date in SQL server 2000

Question Posted / rajkumar v

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

Answer Posted / rajkumar v

select convert(varchar,getdate(),105)

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1021

What is an identity column in insert statements?

988

What is importing utility?

942

how can you attach more than 20 ldf files in sql server

1967

What are the advantages of using cte?

976

How will you know when statistics on a table are obsolete?

1044

Does a full backup include transaction log?

924

List the different normalization forms?

939

Is it important for a database administrator to understand the operating system and file access?

943

What happens when the SQL Azure database reaches Max Size?

109

How to download and install sql server 2005 books online?

1110

Tell me what is fill factor?

921

Difference between uniqe index and uniqe constraint?

934

What command is used to rename the database?

964

What are exact numeric data types in ms sql server?

1019