I have a sql server 2000 db that has a carchar field that is currently storying date data in the following format:
June 16
Can I convert that from varchar to datetime or smalldatetime without loss of data? And, if so, what adjustments do I have to make in my ado code to continue to allow my clients to add data. Currently they add date data by selecting a month from one dropdown and the day from another.
Thanks!Create another column and use CONVERT function to conver the date and store. Then delete the old column.
No comments:
Post a Comment