Pages

Monday, November 14, 2011

Query for add two nvarchar time columns

Query this in sql query editor:
select from,convert(nvarchar(10),(convert(datetime,Colname1)+convert(datetime,Colname2)),108) as to from  table


Result will be:

No comments:

Post a Comment