How do we get current date in SQL Server 2000, Oracle, MS Access?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

How do we get current date in SQL Server 2000, Oracle, MS
Access?

Question Posted / honeysukumar

13 Answers
52869 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do we get current date in SQL Server 2000, Oracle, MS Access?..

Answer / lrk

SELECT GETDATE() AS 'Current Date'
GO

Is This Answer Correct ?

66 Yes

20 No

How do we get current date in SQL Server 2000, Oracle, MS Access?..

Answer / rajiv rohilla

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

Is This Answer Correct ?

43 Yes

13 No

How do we get current date in SQL Server 2000, Oracle, MS Access?..

Answer / selvaraj.v

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

Is This Answer Correct ?

33 Yes

7 No

How do we get current date in SQL Server 2000, Oracle, MS Access?..

Answer / sridhar kumar nelanti

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

Is This Answer Correct ?

27 Yes

7 No

How do we get current date in SQL Server 2000, Oracle, MS Access?..

Answer / nikita

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

Is This Answer Correct ?

32 Yes

14 No

How do we get current date in SQL Server 2000, Oracle, MS Access?..

Answer / jayesh l lolariya

select getdate(); in sql server 2000

Is This Answer Correct ?

10 Yes

5 No

How do we get current date in SQL Server 2000, Oracle, MS Access?..

Answer / kaveesh

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

Is This Answer Correct ?

6 Yes

1 No

How do we get current date in SQL Server 2000, Oracle, MS Access?..

Answer / suhel

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

Please tell me the actual command to use

Is This Answer Correct ?

9 Yes

7 No

How do we get current date in SQL Server 2000, Oracle, MS Access?..

Answer / vineet yadav

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

Is This Answer Correct ?

5 Yes

3 No

How do we get current date in SQL Server 2000, Oracle, MS Access?..

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

Is This Answer Correct ?

2 Yes

3 No

Post New Answer