What will be the output of below query in SQL-SERVER?

Select current_timestamp as 'Current date';
Select getdate() as 'Current date';

Posted by vishalneeraj-24503 on 12/4/2013 | Category: Sql Server Interview questions | Views: 2043 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

Both will produce the same output meaning after executing above query,below output will be displayed.

2013-12-04 15:20:38.833
2013-12-04 15:20:38.833

There is No difference between both in sql-server.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What will be the output of below query in MYSQL? ...

Next > : What is the output of below query? Select Quote ...

Comments or Responses

More Interview Questions by vishalneeraj-24503

What is the output of below query? Select Quotename('emp_first_ ...
What is the output of below query? Select Ascii('A') as upp ...
How to give Select row color in Gridview?
What is the correct syntax for referring to an external Javascript fil ...
How do we round the number 9.25 to the nearest integer?
Inside which HTML element or tag do we put the JavaScript?
How many ways to Execute Dynamic Stored Procedures in Sql-Server?
Which HTML attribute is used to define inline styles?

Latest Interview Questions

How to assign a value to a textbox through javascript?
DB2 - Display the employee details who are working from more than 1 an ...
DB2 - Fetch the current date and time in the following format 24/APR ...
DB2 - Find the NAMEs that have an even number of letters in them
DB2 - Find the count of departments having average salary greater than ...
DB2 - Write a query to get the employee name who joined the company re ...
DB2 - Write a query to get the employee name who joined the company re ...
DB2 - Display number of employees in each department, if the departmen ...
More ...

What will be the output of below query in SQL-SERVER? Select current_timestamp as 'Current date'; Select getdate() as 'Current date';

Comments or Responses

What will be the output of below query in SQL-SERVER?

Select current_timestamp as 'Current date';
Select getdate() as 'Current date';