Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is there a better way of selecting information for a date?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Is there a better way of selecting information for a date?
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01219598
Message ID:
01219598
Vues:
76
Consider the following select statement:
SELECT	[Id] 
FROM	[MyTable] 
WHERE	YEAR(DateField) = YEAR(@DateField) AND 
	MONTH(DateField) = MONTH(@DateField) AND 
	DAY(DateField) = DAY(@DateField)
I want to select the records that have the same date as the parameter, but I do not care about the time part of the field or parameter.
Is there another (better) way of doing this?

Thanks,
Einar
Semper ubi sub ubi.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform