select getdate() In SQL Server, We can get current date a

How can you display the current date & current time ?

Question Posted / prabu

Answer Posted / prabu

select getdate()

In SQL Server, We can get current date and time
If this answer is not correct give me feedback

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11632

What is null value in db2?

966

What is cursor with hold option in db2?

1023

What are the prerogatives?

1028

Are view updateable?

994

What is sqlca’s maximum length?

1112

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1003

How do you eliminate duplicate values in db2?

1121

What is the advantage in De-normalizing tables in DB2?

1130

List down the data types in the db2 database.

1052

Is db2 a database?

923

How do you select a row using indexes in db2?

1084

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1051

List out the data types available.

1102

What is package in db2 mainframe?

930