How do we get current date in SQL Server 2000, Oracle, MS
Access?
- 13 Answers
- 50552 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
Does the order of columns in update statements matter?
How do you create an execution plan?
What are the approximate numeric data types?
what is normalization? : Sql server database administration
What is a livelock?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
How does recursive cte works in sql server?
What is the difference between deallocate cursor and close cursor?
When cursors are useful?
How retrieve field names from the table in SQL through JAVA code?
What is partition index in sql server?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What are indexes in sql?
How to loop through result set objects using mssql_fetch_array()?
What are partitioned views and distributed partitioned views?
