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
What happens when converting big values to integers?
How to change the ownership of a schema in ms sql server?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Explain cursor as data base object?
What is the use of tempdb? What values does it hold?
How many types of functions are there in sql server?
Do you know what are the properties of the relational tables?
Tell about MOM Tool(Microsoft Operator Manager)?
What is the purpose of sql profiler in sql server? : sql server database administration
Write a sql query to delete duplicate records from a table called table1
What is cursors?
How to convert character strings into numeric values?
What are different types of statements that are supported by sql?
What is blocking?
When is the use of update_statistics command?