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 |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2010-08-04 : 09:03:05
|
| HiI know how to cast (textdate as datetime)but I now have a text date field and a text time fieldtextadte = 2010-08-02 texttime = 13:44:05I need to convert them together to a single datetime field |
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2010-08-04 : 09:11:52
|
| just figured it outselect cast ([textdate]+' '+[texttime] as datetime) |
 |
|
|
|
|
|
text date and text time field