Download
100% FREE
Office Document APIs for .NET
Online: 687
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
How to get date of 234 days back in SQL?
Posted by
Bhakti
on 11/24/2009 | Category:
Sql Server Interview questions
| Views: 7053
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Answer:
SQL :
SELECT DATEADD(dd,-234,getdate())
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< Previous :
What is SIGN() ?
Next > :
Write and justify output of - select nullif('test' ...
Comments or Responses
Posted by:
Lakhangarg
on: 11/26/2009
HI-
You can use this too:
SELECT GETDATE()-234
Thanks & Regards
Lakhan Pal Garg
Login to post response
More Interview Questions by Bhakti
Write and justify output of - select nullif('test','test')
Return type of RAND() is...
To terminate SQL Server immediately, used is…
SET OFFSETS specified settings are in effect at…
SET NOCOUNT specified settings are in effect at…
This is used to terminate a query when an overflow or divide-by-zero e ...
Can you control concatenation of string values with null values? How ?
What will you do if you need to create clustered index on more than on ...
Latest Interview Questions
Webservices are created with the following two files
In how many ways you can deploy an Asp.Net Application?
Name the classes that are contained in System.Data NameSpace?
Name the classes are found in System.Data.Common NameSpace?
How is body onload() function is different from document.ready() funct ...
Which of the following method is correct to send an Email Message?
Difference between Eval() and Bind()?
What does dollar Sign ($) means in JQuery?
More ...