dalebrumbaugh
asked on
timestamp
I want to preserve the seconds and milliseconds in the timestamp when I assign it to a variable:
select current_timestamp
returns:
2006-06-19 12:00:34.770
Declare @TimeString nvarchar(50)
set @TimeString = (select current_timestamp)
returns:
Jun 19 2006 11:58AM
select current_timestamp
returns:
2006-06-19 12:00:34.770
Declare @TimeString nvarchar(50)
set @TimeString = (select current_timestamp)
returns:
Jun 19 2006 11:58AM
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
select @TimeString = convert(varchar(30),curren