select getdate(); in sql server 2000

How do we get current date in SQL Server 2000, Oracle, MS
Access?

Question Posted / jayesh l lolariya

Answer Posted / jayesh l lolariya

Is This Answer Correct ?

10 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How to verify a user name with sqlcmd tool?

1116

What is raiseerror? What is raiseerror?

1191

Explain what are the restrictions while creating batches in sql server?

1110

How many types of built in functions are there in sql server 2012?

964

Can we use having clause without group by?

1022

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1990

do you know how to configure db2 side of the application? : Sql server database administration

1089

how to avoid cursors? : Sql server database administration

1007

Why truncate is ddl command?

1106

What is the difference between functions and scalar functions?

1274

how many triggers you can have on a table? : Sql server database administration

1012

How do I edit a procedure in sql server?

997

Can we check locks in database? If so, how can we do this lock check?

984

Do you know what is difference between stored procedure and user defined function?

1146

Name few of the dcl commands in sql?

1053