How to use the DateTimeOffset function from mssql

all.js

GitHub: DFEAGILEDEVOPS/MTC

119
120
121
122
123
124
125
126
127
128
table.columns.add('school_id', sql.Int, { nullable: false })
table.create = false
table.columns.add('foreName', sql.NVarChar, { length: 128 })
table.columns.add('lastName', sql.NVarChar, { length: 128 })
table.columns.add('gender', sql.Char, { length: 1, nullable: false })
table.columns.add('dateOfBirth', sql.DateTimeOffset(3), { nullable: false })
table.columns.add('upn', sql.Char(13), { nullable: false })

for (let schoolIdx = 0; schoolIdx < schoolCount; schoolIdx++) {
  for (let pupilIndex = 0; pupilIndex < pupilCountPerSchool; pupilIndex++) {

14

12

11

+ 5 other calls in file

index.js

GitHub: andrglo/mssql-cr-layer

321
322
323
324
325
326
327
328
329
330
  break
case 'datetime':
  if (param.timezone === 'ignore') {
    type = mssql.DateTime2
  } else {
    type = mssql.DateTimeOffset
  }
  break
case 'string':
  if (param.maxLength) {

1

0

2

sql-server.js

GitHub: myself11c/ApiCitas_Node

89
90
91
92
93
94
95
96
97
98
case 'sql.NVarChar':         return sql.NVarChar ;
case 'sql.Time':             return sql.Time ;
case 'sql.Date':             return sql.Date ;
case 'sql.DateTime':         return sql.DateTime ;
case 'sql.DateTime2':        return sql.DateTime2;
case 'sql.DateTimeOffset':   return sql.DateTimeOffset;
case 'sql.SmallDateTime':    return sql.SmallDateTime;
case 'sql.UniqueIdentifier': return sql.UniqueIdentifier ;
case 'sql.Binary':           return sql.Binary;
case 'sql.VarBinary':        return sql.VarBinary;

0

0

0

+ 5 other calls in file