How get current date in SQL server 2000

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

Post New Answer

More SQL Server Interview Questions

What is a Trace frag?Where can we use this?

1 Answers  


Comment,Datatypes are unlimited

0 Answers   IBM,


What is a trigger in sql server?

0 Answers  


What is open database communication (odbc)?

0 Answers  


How to declare a cursor with "declare ... Cursor" in ms sql server?

0 Answers  






Why foreign key column allowing null values even a parent tables reference key column not having null value..

2 Answers   IBM,


What is blocking and how would you troubleshoot it? : sql server database administration

0 Answers  


What are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,


What do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  


Which command displays the SQL command in the SQL buffer, and then executes it?

3 Answers   TCS,


Can group by be used without aggregate functions?

0 Answers  


i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

3 Answers   NIIT,


Categories