| description | CONVERT Function Limitations | ||
|---|---|---|---|
| title | CONVERT Function Limitations | Microsoft Docs | ||
| ms.custom | |||
| ms.date | 01/19/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | connectivity | ||
| ms.reviewer | |||
| ms.technology | connectivity | ||
| ms.topic | reference | ||
| helpviewer_keywords |
|
||
| ms.assetid | 3c81fc58-57f0-4dd7-be16-2b146eb15cbc | ||
| author | David-Engel | ||
| ms.author | v-davidengel |
Type conversion failures result in the affected column being set to NULL.
Neither the DATE nor TIMESTAMP data type can be converted to another data type (or itself) by the CONVERT function.