Is it possible, i am sure it is. that i can us a combination of a getdate and datename within a query to be able to achaive a where command?
say that i have a query like this
Select col1, co...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20972792.html
Why is DateName showing all January when I know it's not. If I remove DateName, I get numbers for each month like 1,4,2,5 which should be converted to varying month names but they're all coming ou...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21859718.html
part of a query i have is attempting to display a subscribers expiration ... that is the last issue, like: "May-06"
the rule is that if their expiration date is the 1st through the 14th, then th...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21891714.html
I am using datepart in my VB.net code which is returning a month number. How to I get that to a name?
http://www.experts-exchange.com/Programming/Languages/.NET/Q_22661939.html
Hello Experts,
The following Select statement returns the day of the week. Does anyone know how to just return the first 2 characters of the weekday?
SELECT DISTINCT VisitDate, DATENAME(dw, V...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2272...
Using Sybase ASE 12.5.4 and I need to parse a datetime entry into a date and time column separately, separately. I am currently using the datename function to build a string for each column, as se...
http://www.experts-exchange.com/Database/Miscellaneous/Q_22729938.html
I am trying to write a report for our end user that counts the number of application types submitted by week and groups them by month.
It would be something like:
January Agent...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21529257.html
SELECT datename(yyyy, orders_AuthDate) AS X,
ISNULL(SUM(orders_Subtotal + shipping_Cost - discount_Amount),0) AS Y1,
ISNULL(COUNT(orders_Id),0) AS Y2
FROM tbl_Orders
WHERE orders_AuthDate ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21168027.html
The following query counts from a temporary table, and then displays the results grouped by month. The problem is that January 07 is now appearing before December 06 in the results, which isn't qu...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22108026.html
Hi all
How to get date like 01/01/2001
bellow attdate will store in by database like this attdate = '2000-09-26 00:00:00.000'
select distinct month = DATENAME(mm,attdate), attdate = DATEPA...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20161979.html
