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 |
|
ALBean
Starting Member
12 Posts |
 Posted - 2004-06-02 : 00:00:25
|
| Is there any difference between cast and convert (besides syntax?) |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-02 : 00:05:19
|
| CAST is SQL-92 compatible. CONVERT is not. CONVERT offers more functionality be allowing you to specify a style on the conversion (for example date converted as yyyymmdd).MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
ALBean
Starting Member
12 Posts |
Posted - 2004-06-02 : 15:39:59
|
| Thanks, Derrick. |
|
|
|
|
|
|
Cast vs Convert