|
Monday, 26 December 2011 23:51 |
The DATEPART() function is used to return a single part of a date/time, such as year, month, day, hour, minute, etc.
Syntax
DATEPART(datepart,date)
The following SELECT statement:
SELECT DATEPART(yyyy,OrderDate) AS OrderYear,
DATEPART(mm,OrderDate) AS OrderMonth,
DATEPART(dd,OrderDate) AS OrderDay,
FROM Orders
WHERE OrderId=1
OUTPUT
OrderYear OrderMonth OrderDay
2008 11 11
 Read more: |
|
Monday, 19 September 2011 09:59 |
Hi All,
Please check out the following links.....
http://mindstick.com/Articles/b1984687-85b1-469f-b874-c6b0fd4f1d48/?Resizing%20Image%20in%20C#
Thanks !!!! Read more: |