select sysdate from dual; It works in ORACLe 10g. Kaveesh

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

Question Posted / kaveesh

Answer Posted / kaveesh

select sysdate from dual; It works in ORACLe 10g.
Kaveesh

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What will be query used to get the list of triggers in a database?

988

How we can compare two database data?

925

what are isolation levels? : Sql server database administration

972

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

954

Explain what is use of dbcc commands?

1039

What is DCL?

1033

What are the operating modes in which database mirroring runs?

1064

What is the distinction amongst delete and truncate?

1048

what's sql server? : Sql server database administration

979

What is a unique key constraint?

1010

can you implement data mining in SSRS?

146

How does clustered and non clustered index work?

906

what is raid? : Sql server database administration

1018

Can you explain about buffer cash and log cache in sql server?

934

What are data driven subscriptions?

112