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
What is the use of “join” in sql server?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What is unpivot?
How to end a stored procedure properly in ms sql server?
What are the different authentication modes in sql server?
How to recreate an existing index in ms sql server?
How to install sql server 2005 express edition?
How to find the version of sql server? : sql server database administration
What is normalization of database? What are its benefits?
Tell me can we use custom code in ssrs?
Do you think BCNF is better than 2NF & 3NF? Why?
What is the bookmark lookup and rid lookup?
how will add additional conditions in sql?
How to remove duplicate rows from table except one?
Explain trigger and its types?