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

What are the types of dml?

978

What do you understand by a view?

996

How to maintain a fill factor in existing indexes?

1006

What is an index in a database?

979

What are subquery and its properties?

1049

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

1929

Create and insert into temp table in sql server?

1030

What is the function of sql server agent windows service?

1095

How check triggers in sql server?

991

How to create user defined functions with parameters?

1231

Explain the disadvantages of cursors?

1138

What is built-in function?

1004

What is read committed?

1084

Why truncate is ddl?

1087

What are the different types of upgrades that can be performed in sql server?

1175