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
What are the components of sql server service broker?
What are Spatial data types in SQL Server 2008
What are the Advantages of using CTE in sql server?
What the class forname () does?
where can you add custom error messages to sql server? : Sql server administration
How to create nested stored procedure?
How to create a simple table to test triggers in ms sql server?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What number sorts of privileges are accessible in sql?
How each E-R model constructs can be mapped to the relational model?
What is database dimension? : sql server analysis services, ssas
Is the primary key column of a table an index in ms sql server?
What are the elements of dbms?
Do you know the policy based administration feature of sql server 2008?
List the various tools available for performance tuning?