Convert nvarchar type fields to new date type field. - repost

已取消 已发布的 Nov 5, 2013 货到付款
已取消 货到付款

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 ).

.NET ASP C# 编程 数据库管理 SQL

项目ID: #5098340

关于项目

3个方案 远程项目 活跃的Nov 6, 2013

有3名威客正在参与此工作的竞标,均价$21/小时

finecodervw

Hi, Let me introduce myself as an expert in Database design and analysis. I have worked on several database technologies like MS Access , SQL Server, Oracle,MySQL etc. I am well versed with writing stored procedu 更多

$20USD 在1天里
(26条评论)
5.0
daipayan

I complete this in 4hrs. maximum. You can try my service as I am very much well-versed with MS SQL and can do your job in a flash!

$19USD 在1天里
(2条评论)
2.5
sabari09

I am a intermediate in database administration so i could be able to do the work i have got the good idea of your project and will do the task within a day

$25USD 在1天里
(0条评论)
0.0