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 |
|
Huascar82
Starting Member
6 Posts |
 Posted - 2007-11-19 : 14:55:41
|
| Hi Everybody.So as the subject states, I'm a total sql noob. I have a database in SQL 2k5 that was transfered over from an acces DB. In the sql db there are a few fields using nvarchar(255) but the data held is actually dates and times. I need to convert these over to datetime format but do no know how. Also, not all rows have a full mm/dd/yyyy hh:mm format. some hold only the date and can be seen as either m/d/yyyy or full out mm/dd/yyyy format. If anyone can help with this that would be great.Thanks |
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-19 : 15:05:53
|
| post your table & data and someone can better assist. short answer CONVERT function. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
total sql noob help