SQL eqivalent to VB FIX or INT?

[Peter Kaufman]

Hi,

Is there anyway with SQL to return just the portion to the left (or
right) of the decimal place like FIX or INT in VB?

Specifically, I am trying to return just the hh:mm of a datetime
field.

Thanks,

Peter

[Gert-Jan Strik]

These are quite a few different questions.

For extracting the hh:mm out of a datetime, you could use
CONVERT(char(5),MyDateColumn,108).

You can get the portion left of a decimal point with
CAST(MyDecimalColumn AS int) or FLOOR(MyDecimalColumn).

Gert-Jan
Peter Kaufman wrote:

Hi,

Is there anyway with SQL to return just the portion to the left (or
right) of the decimal place like FIX or INT in VB?

Specifically, I am trying to return just the hh:mm of a datetime
field.

Thanks,

Peter