How get current date in SQL server 2000

Question Posted / ravi2514

Answers were Sorted based on User's Feedback

How get current date in SQL server 2000..

Answer / sangeetha

select getdate()

Is This Answer Correct ?

27 Yes

1 No

How get current date in SQL server 2000..

Answer / shyamsri83

select getdate()

Is This Answer Correct ?

4 Yes

0 No

How get current date in SQL server 2000..

Answer / rajkumar

select getdate()

Is This Answer Correct ?

2 Yes

0 No

How get current date in SQL server 2000..

Answer / rajkumar v

select convert( varchar(20), getdate(), 103)

Is This Answer Correct ?

1 Yes

0 No

How get current date in SQL server 2000..

Answer / saket

now()

Is This Answer Correct ?

1 Yes

2 No

How get current date in SQL server 2000..

Answer / hajee

select sysdate from dual

Is This Answer Correct ?

0 Yes

1 No