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

Using the customer, and order table in northwind database, please write a query to produce xml?

0 Answers  


Is sql server a database?

0 Answers  


What is INTVAL( )and where we use Plz any body help me

1 Answers  


How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change Table,Stored Procd. Then I Find Which SP,Table We Have Edit/Change in Seven Dayes

1 Answers   INDUS,


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

0 Answers   HP,






What is Trigger?

3 Answers   Misys,


Do you know what are the ways available in sql server to execute sql statements?

0 Answers  


What are the system database in sql server 2008?

0 Answers  


Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  


What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,


Can we perform backup restore operation on tempdb?

0 Answers  


What is the largest component inside a field?

0 Answers  


Categories