System Time

[HLPCH]

Hi, Could someone tell me what function I need to use to get the system Time?

I know that the Getdate() only gives the currentdate plus time. But I only need the time portion in the format hours:minutes:seconds

Thanks

CS

 

[vongrunt]

There is no time type in SQL Server - you must use char/varchar:

select convert(varchar(8), getdate(), 108)

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[HLPCH]

Thanks. It worked.

CS

 

[DrSql]

Try this
SELECT CONVERT(CHAR(8), GETDATE(), 108)

Dr.Sql
Good Luck.