diff options
| author | Mark Newnham <mark@newnhams.com> | 2018-07-08 17:58:15 -0600 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2018-07-08 17:58:15 -0600 |
| commit | e167895234555119b8122f331b54aad4680ad246 (patch) | |
| tree | ece068e0cfa4acfbf222219b14b5f4ac9bcf5937 | |
| parent | 2d3d5428641b211ab3743b6c9cc0ee0c4c2317b0 (diff) | |
| download | adodb-e167895234555119b8122f331b54aad4680ad246.tar.gz adodb-e167895234555119b8122f331b54aad4680ad246.tar.bz2 adodb-e167895234555119b8122f331b54aad4680ad246.zip | |
getInsertSql creates incorrect format for SQL Server time field, see #432
By treating Time format fields as time for insertion purposes, ADOdb assumed that it needs to create a datetime field, but the insertion format is a character field, eg '23:56.1245', instead of 5033000200.
| -rw-r--r-- | drivers/adodb-mssqlnative.inc.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/drivers/adodb-mssqlnative.inc.php b/drivers/adodb-mssqlnative.inc.php index f95aad59..0143aa99 100644 --- a/drivers/adodb-mssqlnative.inc.php +++ b/drivers/adodb-mssqlnative.inc.php @@ -916,7 +916,7 @@ class ADORecordset_mssqlnative extends ADORecordSet { { $_typeConversion = array( -155 => 'datetimeoffset', - -154 => 'time', + -154 => 'char', -152 => 'xml', -151 => 'udt', -11 => 'uniqueidentifier', |