I cannot convert nvarchar(25) to datetime.
201503171512
I need to create two columns
datetime dd-mm-yyyy-mmmm - 15-Mar-2015-1512
second column named time
1512 pm.
i've tried CONVERT(nvarchar(25),CONVERT(DATE,column,106),103) AS AdmittedDatetime,
thanks.