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

Answer Posted / sridhar kumar nelanti

we use getdate()in SQL server to view current date and in
oracle we use sysdate().

Is This Answer Correct ?    27 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are the different index configurations a table can have?

687


What is etl - extraction, transformation, and loading?

520


Explain where clause?

533


What is a matrix in ssrs?

101


What is an index. What are the types?

582






What do you mean by table and field in sql?

550


What is postgresql server?

508


how to determine the service pack currently installed on sql server? : Sql server database administration

561


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1212


How does the report manager work in SSRS?

116


What is the syntax to execute the sys.dm_db_missing_index_details?

580


What is acid mean in sql server?

570


How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

675


What does the automatic recovery do?

572


Explain DBCC?

566