Convert nvarchar type fields to new date type field.

This project was successfully completed by aaravsoft for $20 USD in a day.

Get free quotes for a project like this
Project Budget
$10 - $30 USD
Completed In
1 day
Total Bids
Project Description

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

Completed by:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online