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 |
|
varalakshmi
Yak Posting Veteran
98 Posts |
 Posted - 2009-05-20 : 02:04:14
|
| Hi ,I need to convert varchar to date data type using any functions in derived column transformation. please help |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-05-20 : 02:06:44
|
check out convert() and cast
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2009-05-26 : 11:40:34
|
| What is the format of the varchar field?http://www.sqlserver007.com |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-26 : 12:05:32
|
| use (DT_DATE) or (DT_DBTIMESTAMP) |
|
|
|
|
|
|
convert varchar to date