How do we get current date in SQL Server 2000, Oracle, MS
Access?
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
Can we insert data into a view?
What are the new data types are introduced in sql 2000?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
How to find the version of sql server? : sql server database administration
How do I view a script in sql server?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
Why it is recommended to avoid referencing a floating point column in the where clause?
What is the purpose of sql profiler in sql server?
What is the security principal at the database level that represents your session?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Is foreign key a primary key?
Can you please explain the difference between function and stored procedure?
How can we determine what objects a user-defined function depends upon?
Why I have to use stored procedures?
What is ms sql server reporting services?