Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
converting nvarchar to datetime field
thanks for the tips guys, I used the ASP page suggestion and it worked well for the most part. so now everything is in the MM/DD/YYYY format. but now for some reason it won't let me conver the column into datetime giving me an "arithmetic overflow error converting to data type datetime...- zerodot
- Post #5
- Forum: Microsoft SQL Server: Programming
-
converting nvarchar to datetime field
I have been given the task of selecting from a small database (28,000 records) certain records that indicate a date over under 6 years old. The only problem is that the DBA didn't make the column a datetime field when he designed the database, he made an nvarchar. So when I'm trying to use the...- zerodot
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
