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

How can you display the current date & current time ?

Question Posted / prabu

7 Answers
12877 Views
Cap Gemini, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which isolation level provides highest data integrity?

1114

How do I change the column size in db2?

1151

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3202

What is the maximum length of sqlca?

1521

Why do we use cursor?

1096

What is the use of with ur in db2?

1052

What is db2 command?

1031

Discuss about db2 bind?

1092

can we view the access paths created by dbrm ? how ? thx

7085

What is the difference between spufi and qmf?

1126

What does a deadlock mean in DB2?

1160

What is the picture clause of null indicator variable?

1136

What is load utility in db2?

1179

How does coalesce work?

1012

Is ibm db2 open source?

1071