Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shpinoza1980
Starting Member
17 Posts |
 Posted - 2011-01-30 : 05:27:51
|
| Hello,I have a nvarchar column with string of the from dd/mm/yyyyHow do I convert the entire column from vnvarchar to dataTime dataType of the same format?thanks a lot |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-01-30 : 07:12:59
|
SQL Server is storing datetime datatype in an internal format.The format to show the value is a presentation issue and has nothing to do with the stored format.How ever, to convert your character value to datetime:convert(datetime,YourColumn,103)should work.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
convert string dd/mm/yyyy to dateTime