PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WINDEV 2024 → Could not save milliseconds to MS SQL
Could not save milliseconds to MS SQL
Started by Markus, Feb., 09 2017 8:14 AM - No answer
Registered member
9 messages
Posted on February, 09 2017 - 8:14 AM
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