i donot abt the SQLserver2000and MSaccess.But in ORACLE we get current da

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

Question Posted / nikita

Answer Posted / nikita

i donot abt the SQLserver2000and MSaccess.But in ORACLE we
get current date by following SQLstmt:
SELECT sysdate() FROM DUAL;

Is This Answer Correct ?

32 Yes

14 No

Please Help Members By Posting Answers For Below Questions

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1991

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

991

What number aggregate functions are accessible there in sql?

1125

what is dbcc? : Sql server database administration

1075

What is compound operators?

1111

Explain the various types of concurrency problem?

1232

Can you explain different types of joins?

984

When should you use an instead of trigger?

1017

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

1005

How to execute stored procedure in select statement sql server?

1104

how to create “alternate row colour”?

152

What is user defined datatypes and when you should go for them?

1064

Is there any difference between primary key and unique with the not null condition?

997

Can a table be created inside a trigger?

1010

Your table has a large character field there are queries that use this field in their search clause what should you do?

920