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

What is data modeling and Reterminal integrity?

0 Answers  

How to download and install the scaled-down database adventureworkslt?

0 Answers  

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

Can a unique index be created on a column, which contains null?

0 Answers  

Will sql server 2005 allow you to reduce the size of a column?

0 Answers  

Explain about temporary stored procedure?

0 Answers  

How to compare the top two records using sql?

0 Answers  

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

what is curser.

9 Answers  

Explain cross join or cartesian product in sql?

0 Answers  

How to execute a sql statement using mssql_query()?

0 Answers  

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

0 Answers