Skip to content

Commit cba22c5

Browse files
authored
Update datatypes
1 parent 86a6888 commit cba22c5

1 file changed

Lines changed: 10 additions & 8 deletions

File tree

docs/machine-learning/python/python-libraries-and-data-types.md

Lines changed: 10 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -3,8 +3,7 @@ title: Convert Python and SQL data types
33
description: Review the implicit and explicit data type conversions between Python and SQL Server in data science and machine learning solutions.
44
ms.prod: sql
55
ms.technology: machine-learning-services
6-
7-
ms.date: 06/25/2020
6+
ms.date: 06/30/2020
87
ms.topic: conceptual
98
author: dphansen
109
ms.author: davidph
@@ -30,19 +29,22 @@ This table lists the implicit conversions that are provided. Other data types ar
3029

3130
|SQLtype|Python type|Description
3231
|-------|-----------|---------------------------------------------------------------------------------------------|
33-
|**bigint**|`numeric`|
34-
|**binary**|`raw`|
32+
|**bigint**|`float64`|
33+
|**binary**|`bytes`|
3534
|**bit**|`bool`|
3635
|**char**|`str`|
36+
|**date**|`datetime`|
37+
|**datetime**|`datetime`|Supported with SQL Server 2017 CU6 and above (with **NumPy** arrays of type `datetime.datetime` or **Pandas** `pandas.Timestamp`). `sp_execute_external_script` now supports `datetime` types with fractional seconds.|
3738
|**float**|`float64`|
3839
|**int**|`int32`|
3940
|**nchar**|`str`|
4041
|**nvarchar**|`str`|
4142
|**nvarchar(max)**|`str`|
42-
|**real**|`float32`|
43-
|**smallint**|`int16`|
44-
|**tinyint**|`uint8`|
45-
|**datetime**|`datetime`|Supported with SQL Server 2017 CU6 and above (with **NumPy** arrays of type `datetime.datetime` or **Pandas** `pandas.Timestamp`). `sp_execute_external_script` now supports `datetime` types with fractional seconds.|
43+
|**real**|`float64`|
44+
|**smalldatetime**|`datetime`|
45+
|**smallint**|`int32`|
46+
|**tinyint**|`int32`|
47+
|**uniqueidentifier**|`str`|
4648
|**varbinary**|`bytes`|
4749
|**varbinary(max)**|`bytes`|
4850
|**varchar(n)**|`str`|

0 commit comments

Comments
 (0)