How do we get current date in SQL Server 2000, Oracle, MS
Access?
Answer Posted / selvaraj.v
In Access 'Select date()'
In Oracle 9i 'Select Sysdate from dual;'
In SQL Server 2000 'Select Getdate()'
| Is This Answer Correct ? | 33 Yes | 7 No |
Post New Answer View All Answers
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
How do you implement session management in SQL Server mode?
How to find the second highest salary of an employee?
What is a self join in sql server?
What are the different kinds of ssrs reports?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What is a view in sql?
what are user defined datatypes? : Sql server database administration
What are distributed partitioned views?
What is ssl in sql server?
What is the difference between composite index and covering index?
What is the return type of executeupdate ()?
What is table level trigger?
What is dbcc command in sql server?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?