How Do I Convert Varchar Data Type Into Datetime Data Type In Asp.Net

Question

0.00/5 (No votes)

See more:

i want to convert varchar data type into datetime data type in asp.net while updating my table2 from table1

table1

eid name joiningdate
1 abc 10/11/14(varchar(20) -datatype

table2

id name joiningdate
1 [null] [null] (datetime)-datatype

i tired to update name n date using eid=id join .
name was geting updated but when i used joining date to store in table2 .
it was showing error.

kindly help me with this problem to update the data..

Posted 23-Jul-14 23:17pm

10923679

Add a Solution

Comments

Wombaticus 24-Jul-14 5:33am

I am not clear what ASP.NET has to do with this, as you seem to be implying you are trying to do this via a SQL statement? I suggest you look at the CAST and CONVERT functions in SQL

10923679 24-Jul-14 5:37am

okay ..

thanks

10923679 24-Jul-14 5:39am

well i have two table.
both have different datatype and filled with values
i want to update my table2 with the help of table1 using asp.net
normal update fromone table to another. (filling the null values)
but becos dates have different datatype so i am not to update it

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-07-24T00:22:00

Rule one of databases: always use the appropriate datatype.
And VARCHAR is not an appropriate datatype for storing dates!

So edit your Table1 and change it to DateTime - and reload all the data to make sure it's correct, because 10/11/14 can be read as dd/MM/yy, MM/dd/yy, yy/mm/dd, or various other formats. This is why it's important to use the right datatype! You generally know when you are inserting the data what format it is, because your code that interacts with the user can check on his locale - but SQL can't!