How to use the DateTime function from mssql

commercial-release.js

GitHub: DEVFBA/gtc-services-portal-api

16
17
18
19
20
21
22
23
24
var udtCommercialRelease = new sql.Table();
// Las columnas deben corresponder con las creadas en la base de datos.   
udtCommercialRelease.columns.add('Id_Item', sql.VarChar(50));  
udtCommercialRelease.columns.add('Id_Country', sql.VarChar(10));
udtCommercialRelease.columns.add('Id_Status_Commercial_Release', sql.SmallInt(2));
udtCommercialRelease.columns.add('Final_Effective_Date', sql.DateTime(8));
udtCommercialRelease.columns.add('Modify_By', sql.VarChar(50));
udtCommercialRelease.columns.add('Modify_Date', sql.DateTime(8));
udtCommercialRelease.columns.add('Modify_IP', sql.VarChar(20));

0

0

0

get-params.js

GitHub: ImoucheG/machinepack-sqlserver-adapter

103
104
105
106
107
108
109
110
111
112
  break;
case 'date':
  type = mssql.Date();
  break;
case 'datetime':
  type = mssql.DateTime();
  break;
case 'float':
  type = mssql.Float();
  break;

0

0

1

+ 3 other calls in file