Querying datetime column by date

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Querying datetime column by date

Message

18/02/2011 10:26:37

18/02/2011 10:06:01

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Versions des environnements

SQL Server:

SQL Server 2000

Divers

Thread ID:

01500708

Message ID:

01500715

Vues:

Thanks, Naomi
That looks good.
I found this too- it strips the time off
:
CAST(FLOOR(CAST(mydatetimecolumn AS float))AS datetime)

Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.