How I get time value:

I have value '1/1/2005 12:53:10' (smalldatetime). I wanna get time value of
it. So I will get '12:53:10'. How to get? and what type suitable for this
problem?CONVERT(CHAR(8), your_small_date_time, 8)
Jacco Schalkwijk
SQL Server MVP
"Bpk. Adi Wira Kusuma" <adi_wira_kusuma@.yahoo.com.sg> wrote in message
news:ud9QH43lFHA.3656@.TK2MSFTNGP09.phx.gbl...
>I have value '1/1/2005 12:53:10' (smalldatetime). I wanna get time value of
> it. So I will get '12:53:10'. How to get? and what type suitable for this
> problem?
>|||hi
hope this will give u an idea
select CONVERT(CHAR(8), getdate(), 8)
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Bpk. Adi Wira Kusuma" wrote:

> I have value '1/1/2005 12:53:10' (smalldatetime). I wanna get time value o
f
> it. So I will get '12:53:10'. How to get? and what type suitable for this
> problem?
>
>