Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
First Saturday Of Fiscal Month
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
01448576
Message ID:
01448595
Vues:
41
Ok, this is strange:
DECLARE @FirstSat VARCHAR(11)

DECLARE @Temp VARCHAR(46)
SELECT @Temp = '2010-04-Apr'
DECLARE @DATE DATETIME
 
SELECT @DATE = LEFT(@Temp,7) + '-01'
 
SELECT TOP 1 @FirstSat = DATEADD(dd,number,@DATE)
	FROM master..spt_values
	WHERE type = 'p' AND
		  DATEPART(dw,DATEADD(dd,number,@DATE)) = 7
	ORDER BY 1 ASC

SELECT @FirstSat


/*

DECLARE @Temp VARCHAR(46)
SELECT @Temp = '2010-04-Apr'
DECLARE @DATE DATETIME
 
SELECT @DATE = LEFT(@Temp,7) + '-01'
 
SELECT TOP 1 DATEADD(dd,number,@DATE) AS FirstSat 
	FROM master..spt_values AS FirstSat
	WHERE type = 'p' AND
		  DATEPART(dw,DATEADD(dd,number,@DATE)) = 7
	ORDER BY 1 ASC
*/
Run both queries. They return different formats. I need back a DATETIME.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform