Posted by Dale on 01/21/07 16:35

Thanks for all the help. Figured it out...here's what I did:

select convert(varchar(10), DateInitiated, 108)
....
....


"Dale" <dale@cox.is.over.rated> wrote in message
news:mfJsh.2144$jA.1625@bignews1.bellsouth.net...
>A table has a field containing the date and time. Example 2006-2-20
>08:11:44.123...field name is DateInitiated. I can extract the month, day
>and year by using Day(DateInitiated), Month(DateInitiated),
>Year(DateInitiated). How would the time be extracted for hours, minutes and
>seconds?
>
> Thanks!
>

[Back to original message]