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

Answer Posted / rajiv rohilla

In Access We USE 'Select Date()'
In Sql server 2000 'Select getdate()'
In Oracle 'Select SysDate() from dual'

Is This Answer Correct ?    43 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can you check the level of fragmentation on a table? : Sql server administration

709


What are the differences between having and where clause.

709


What is tabulation?

704


Why use view instead of a table?

708


what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

683






Difference between drill down and drill through report.

726


your distribution database is full what will u do

1871


How do you delete a trigger?

742


What is an index in a database?

706


How to join two tables in a single query in ms sql server?

716


Explain powershell included in sql server 2008?

766


Can two different columns be merged into single column? Show practically?

820


How can we solve concurrency problems?

778


Call by value and call by reference in procedure and function, with NOCOPY.

1045


Explain what is public role in sql server?

788