Answer / lrk

SELECT GETDATE() AS 'Current Date'
GO

Answer / rajiv rohilla

In Access We USE 'Select Date()'
In Sql server 2000 'Select getdate()'
In Oracle 'Select SysDate() from dual'

Answer / selvaraj.v

In Access 'Select date()'
In Oracle 9i 'Select Sysdate from dual;'
In SQL Server 2000 'Select Getdate()'

Answer / sridhar kumar nelanti

we use getdate()in SQL server to view current date and in
oracle we use sysdate().

Answer / nikita

i donot abt the SQLserver2000and MSaccess.But in ORACLE we
get current date by following SQLstmt:
SELECT sysdate() FROM DUAL;

Answer / jayesh l lolariya

select getdate(); in sql server 2000

Answer / kaveesh

select sysdate from dual; It works in ORACLe 10g.
Kaveesh

Answer / suhel

This command is not working, I transferred MySQL database
to SQL Server 2000 database.

Please tell me the actual command to use

Answer / vineet yadav

In Sql Server It will be ( Select getDate() )
And in ORacler (Select SysDate() from dual;)

Answer / 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

How to set a database state to offline in ms sql server?

0 Answers  

What extended events?

0 Answers  

What is the purpose of floor function?

0 Answers  

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

What is 2nf normalization?

0 Answers  

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10

7 Answers  

How many non clustered indexes there can be on table ?

0 Answers  

What guidelines should be followed to help minimize deadlocks?

0 Answers  

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

Tell about MOM Tool(Microsoft Operator Manager)?

0 Answers  

what is blocking? : Sql server database administration

0 Answers  

What types of integrity are enforced by a foreign-key constraint

1 Answers