The date and time field columns are nvarchar data type and using below formula in calculated column to get the output, the calculated column is of seconddate datatype
date:20140306 time 021259
string(date("date"))+String(' ')+string(time("time"))
getting error while displaying the output
string(date("date"))+string(' ')+string("time")
output not showing correct value eg: 2014-03-06 02:00:00.0