I need help formating the Time from a smalldatetime field. 1

[elmorro]

Hi all,
I have written a query that returns the StartTime field, but it returns it with the date attached to it:
1900-01-01 06:30:00.000

How can I format the field so that it only returns the time:
06:03 ?


Thanks is advance,
elmorro

 

[gmmastros]

Select Convert(VarChar(20), [!]YourDateTimeColumn[/!], 108)

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[elmorro]

Thanks gmmastros. That helped alot, but I am still getting the time like this:
06:03:00
Is there any way to drop the trailing zeros and have it look like this:
06:03


elmorro

 

[gmmastros]

Select [!]Left([/!]Convert(VarChar(20), YourDateTimeColumn, 108) [!], 5[/!])


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[ptheriault]

Try this.

select convert(CHAR(5), getdate(), 108)

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[gmmastros]

Paul, I thought of that about 10 nanoseconds after clicking the submit button.

elmorro, use Paul's version instead. It is slightly better.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[ptheriault]

- Paul
- If at first you don't succeed, find out if the loser gets anything.