Sergey, did you test this? Here are my results:
select convert(varchar,getdate(),114)
retuns: 08:01:30:890
select replace(convert(varchar,getdate(),114),':','')
returns: 08 01 30 890
Notice the spaces that are being returned.
>You can use T_SQL REPLACE() function to remove colons.
SELECT REPLACE(CONVERT(varchar(32), getdate(),114), ':', '')
>
>>SQL Server returns a value from the following command
>>with colons (:) and down to the milisecond.
>>
>>select convert(varchar,getdate(),114)
>>
>>All I want is the time portion returned without the colons
>>like this in VFP:
>>
>>xx= '15:36:31:293'
>>?left(chrtran(xx,':',''),6)
>>
>>
>>Can it be done in SQL Server via T-SQL?