Need help to convert 2 fields (nvarchar datatype) to a date field ( date datatype ) in MS Sql server 2008r2. For example: field1 ='22nd' , field2 = 'May, 2013'; both these fields are in nvarchar ( 50). Prefer a store procedure or a SQL update to insert a date value into a date field3 according to those nvarchar field1&field2. The result should be '2013-05-22' in the field3 ( date datatype ).
14 freelancers are bidding on average $24 for this job
Dear Sir, I am Professional Software Developer, I am Linux Advanced Developer, I am Database Developer and designer. I can Handle your job and do everything extremely Grate. Regards,
i can do it for you, i have experience working with MS SQL SERVERS, and sql language and i know to make a stored procedure so your task could be accomplished verry fast at a small price
Hi, I will make the database script to read data from two fields and insert into the new field like you required. Please contact me for your good results. Thank you, Khoa Ho.
hello I have 2 year experience in sql server, i can solve your problem of convert nvarchar to date type filed. i can solve this issue within 15mint . Thnaks