[dotenv@17.3.1] injecting env (6) from .env -- tip: 🛡️ auth for agents: https://vestauth.com
Trying to create: {
  DateEntered: 2026-05-05T13:25:07.138Z,
  DateInstalled: 2026-05-05T13:25:07.138Z,
  WorkOrderId: 0,
  ServiceDate: 2026-05-08T00:00:00.000Z,
  ServiceTime: 540,
  Notes: 'test',
  Resolution: 'test',
  Priority: 1,
  InstallerId: 13,
  ApplicationId: 33234,
  EstimatedDuration: 60,
  EstimatedCost: 475,
  EnteredBy: 'System',
  Printed: false,
  Emailed: false,
  Text: true,
  PaymentForm: 1,
  TaxValue: 0,
  DiscountValue: 0,
  ExtraCost: 0,
  ExtraCostDescription: null,
  UserID: 'AJAYSH',
  DateCompleted: 2026-05-30T00:00:00.000Z
}
Executing (default): SELECT 1+1 AS result
Executing (default): INSERT INTO [ServiceAppointments] ([DateEntered],[DateInstalled],[EstimatedDuration],[EstimatedCost],[EnteredBy],[Priority],[ServiceDate],[ServiceTime],[Resolution],[DateCompleted],[Printed],[Emailed],[ApplicationId],[UserID],[InstallerId],[Notes],[ExtraCost],[ExtraCostDescription],[PaymentForm],[TaxValue],[DiscountValue],[Text],[WorkOrderId]) OUTPUT INSERTED.[ServiceAppointmentId],INSERTED.[DateEntered],INSERTED.[DateInstalled],INSERTED.[EstimatedDuration],INSERTED.[EstimatedCost],INSERTED.[EnteredBy],INSERTED.[Priority],INSERTED.[ServiceDate],INSERTED.[ServiceTime],INSERTED.[Resolution],INSERTED.[DateCompleted],INSERTED.[Printed],INSERTED.[Emailed],INSERTED.[ApplicationId],INSERTED.[UserID],INSERTED.[InstallerId],INSERTED.[Notes],INSERTED.[ExtraCost],INSERTED.[ExtraCostDescription],INSERTED.[PaymentForm],INSERTED.[TaxValue],INSERTED.[DiscountValue],INSERTED.[Text],INSERTED.[WorkOrderId] VALUES (@0,@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12,@13,@14,@15,@16,@17,@18,@19,@20,@21,@22);
--- Database Connected Successfully (Sequelize) ---
node : Error: Conversion failed when converting date and/or time from character string.
At line:1 char:1
+ node scratch_test.js > test_output2.txt 2>&1
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (Error: Conversi...aracter string.:String) [], RemoteException
    + FullyQualifiedErrorId : NativeCommandError
 
SQL Error: Conversion failed when converting date and/or time from character string.
Error
    at Query.run (C:\xampp\htdocs\apollotek\backend\node_modules\.pnpm\sequelize@6.37.8_tedious@19.2.1_@azure+core-clie
nt@1.10.1_\node_modules\sequelize\lib\dialects\mssql\query.js:107:25)
    at C:\xampp\htdocs\apollotek\backend\node_modules\.pnpm\sequelize@6.37.8_tedious@19.2.1_@azure+core-client@1.10.1_\
node_modules\sequelize\lib\sequelize.js:315:28
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async MSSqlQueryInterface.insert (C:\xampp\htdocs\apollotek\backend\node_modules\.pnpm\sequelize@6.37.8_tedious@
19.2.1_@azure+core-client@1.10.1_\node_modules\sequelize\lib\dialects\abstract\query-interface.js:308:21)
    at async model.save (C:\xampp\htdocs\apollotek\backend\node_modules\.pnpm\sequelize@6.37.8_tedious@19.2.1_@azure+co
re-client@1.10.1_\node_modules\sequelize\lib\model.js:2490:35)
    at async Appointment.create (C:\xampp\htdocs\apollotek\backend\node_modules\.pnpm\sequelize@6.37.8_tedious@19.2.1_@
azure+core-client@1.10.1_\node_modules\sequelize\lib\model.js:1362:12)
    at async testCreate (C:\xampp\htdocs\apollotek\backend\scratch_test.js:32:18)