PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → Could not save milliseconds to MS SQL
Could not save milliseconds to MS SQL
Débuté par Markus, 09 fév. 2017 08:15 - Aucune réponse
Membre enregistré
9 messages
Posté le 09 février 2017 - 08:15
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