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.
Showing posts with label carchar. Show all posts
Showing posts with label carchar. Show all posts
Subscribe to:
Posts (Atom)