Home » SQL Server » How to get and time as simple string? How to get and time as simple string? Nirav Daraniya 19:50 SQL Server SimpleCode : select REPLACE(REPLACE(REPLACE(REPLACE(convert(varchar,getdate(),121),'-',''),':',''),'.',''),' ','') as StrDateTimr OUTPUT: -- /\/ir@\/ <(.'.)> Share: Facebook Twitter Google+ StumbleUpon Digg Delicious LinkedIn Reddit Technorati
0 comments:
Post a Comment
Thanks for comment