PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → Could not save milliseconds to MS SQL
Could not save milliseconds to MS SQL
Iniciado por satmax, 09,feb. 2017 08:14 - No hay respuesta
Miembro registrado
10 mensajes
Publicado el 09,febrero 2017 - 08:14
Windev always set milliseconds to 000:

HReset(UserLog)
UserLog.Datum=SysDateTime()
HAdd(UserLog)


Result in db: 2017-02-08 07:35:17.000, the milliseconds always set to 000

Same when I use a windev query:
INSERT INTO UserLog
(
UNT_ID,
Datum
)
VALUES
(
{ParamUNT_ID},
current_timestamp
)


When i use MS management studio all works fine:
INSERT INTO UserLog
(
UNT_ID,
Datum
)
VALUES
(
0,
current_timestamp
)


result in db is correct: 2017-02-08 07:37:44.577