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

Is db2 a database?

652

Are view updateable?

710

What is the difference between dbm cfg and db cfg file in db2 ?

1104

Who uses db2?

658

When reorg is used?

761

What is a db2 package?

681

What is a cursor in programming?

696

What is the difference between db2 and oracle?

761

What is the role of schema in the db2 database?

757

Is the primary key a clustered index?

724

What is copy pending and check pending in db2?

664

What is netezza database?

664

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

832

What is host variable?

683

How can you count the number of rows from a table tab?

722