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 |
|
aozogu
Starting Member
4 Posts |
 Posted - 2002-05-23 : 12:57:49
|
| I am having a problem converting a column which is a date data to date in MS Access, the coulumn is imported as a number field. It wipes out the entire column soon as I made the changes to date/time. What could be the solution? Thanks for your help. |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-06-21 : 12:54:16
|
| How are you going about converting it?If the number field is formatted properly this should workselect convert(datetime,datefield)if that doesn't work... well, that gets a little more complicated.If it does, create another column in your table called 'Formatted_Datetime' as type datetimeThen runUpdate tablename set formatted_datetime = convert(datetime,datefield)That will populate this new column with properly formatted datetimes Hopefully that answers your question-----------------------Take my advice, I dare ya |
 |
|
|
|
|
|
Data Type