How to use the time portion of a datetime column

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How to use the time portion of a datetime column

Message

18/09/2001 13:02:36

Mike Yeager
MikeYeager.com
Taos, Nouveau Mexique, États-Unis

17/09/2001 20:45:48

Sergey Berezniker
New York, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Re: How to use the time portion of a datetime column

Divers

Thread ID:

00557574

Message ID:

00557971

Vues:

CONVERT(char(5), mydatefield, 8) seems to be just the ticket.

Thanks,
Mike

PS CONVERT is T-SQL, not ANSI SQL, right? I'll have to find another way if the data is in Oracle?

Répondre

Fil

Voir

Click here to load this message in the networking platform