Interested to Buy Any Domain ? << Click Here >> for more details...
How do we get current date in SQL Server 2000, Oracle, MS
Access?
- 13 Answers
- 52344 Views
- I also Faced
- E-Mail Answers
Answer Posted / parmanand
Access 2000 , i have tried.
select date() as CurrDate
select now() as CurrNow 'This will also work but it will
give you time also.
Output
CurrDate
----------
11/17/2009
CurrNow
----------
11/17/2009 11:00:34 PM
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is the purpose of data source?
Write a query to find 5th highest amount paid from the customer table.
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
define and explain the differences between clustered and non-clustered indexes.
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What is difference between count (*) and count 1?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
How to delete an existing row with delete statements in ms sql server?
What is indexing a document?
What are the differences between char and varchar in ms sql server?
What is open database communication (odbc)?
What are scalar functions in sql?
Explain trigger and trigger types?
What are the advantages of using a stored procedure?
How to execute a stored procedure in ms sql server?
