How to get the Day part from the given Date?

Posted by Lakhangarg on 2/22/2010 | Category: Sql Server Interview questions | Views: 4704

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

There are two methods to get the Date part from given date:
DECLARE @GivenDate datetime
SET @GivenDate='2010-02-22 23:06:38.300'

(1) DAY(GETDATE()) Output: 22
(2) DatePart(d,GETDATE()) Output: 22

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : How to get the year part from the given Date?

Next > : How to get the month value/month part from the giv ...

Comments or Responses

More Interview Questions by Lakhangarg

How to get the month value/month part from the given Date?
Can we use Oracle Database as source or destination Database in SSIS?
Name of the containers in SSIS?
Can we write Scripting Language like VB Script and JavaScript in SSIS ...
What is SSIS
Can we create DTS Package in DTS package in SQL Server 2005 or higher ...
What is the difference between .rdl and .rdlc report.
I have regular expression for date: ^[0-1]{1,1}\d{1,1}/[0-3]{1,1}\d{1, ...

Latest Interview Questions

Adding year to a date ??
Adding minutes to a date ??
Adding months to a Date in SQL ??
Which namespace provide classes for integration with WPF and Win32?
What is the use of "System.Windows.Markup" namespace in WPF?
How to define a button USING XAML?
What is WPF?
How can you restrict all the textbox's autocomplete to off in a form ?
More ...