Skip to Content
0
Jun 06, 2018 at 01:29 PM

How to concatenate date and time columns and get output in the format of seconddate

963 Views

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