How to use the DateTimeOffset function from mssql
Find comprehensive JavaScript mssql.DateTimeOffset code examples handpicked from public code repositorys.
GitHub: DFEAGILEDEVOPS/MTC
![DFEAGILEDEVOPS profile picture](/DFEAGILEDEVOPS.png?size=40)
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++) {
+ 5 other calls in file
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) {
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;
+ 5 other calls in file
mssql.connect is the most popular function in mssql (5681 examples)