How to use the time portion of a datetime column

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How to use the time portion of a datetime column

Message

From

18/09/2001 13:02:36

Mike Yeager
MikeYeager.com
Taos, New Mexico, United States

17/09/2001 20:45:48

Sergey Berezniker
New York, United States

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

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

Miscellaneous

Thread ID:

00557574

Message ID:

00557971

Views:

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?

Map

View

Click here to load this message in the networking platform