Home Forums SQL Server 2005 SQL Server 2005 General Discussion convert timestamp to varchar RE: convert timestamp to varchar
navamohank
SSC Journeyman
Points: 85
More actions
September 22, 2009 at 1:44 pm
#1057101
Hi,
You can use it as shown below:
SELECT [master].[dbo].fn_sqlvarbasetostr(@@DBTS)
There is a predefined scalar function in Master database to do this.. 🙂
Regards,
Navamohan K