I have a need to get the current datetime with milliseconds. I created a query to call a view that returns it, but the handler gets the value as with just seconds, even though the same query in SSMS returns milliseconds. Is there a trick to get the toolstep to assign the value with milliseconds?
cheers
Tony

------------------------------
Tony Curoso
American Telesource, Inc.
------------------------------

Date/Time values in handlers only resolve to seconds. You will need to retrieve the value from the database as a string (create a view to do this), convert the date/time portion to a date/time variable and store the milliseconds in a separate, numeric variable.

------------------------------
Steve Owen
Avtex Solutions
------------------------------

Original Message:
Sent: 04-18-2018 21:34
From: Tony Curoso
Subject: sql query to return datetime

I have a need to get the current datetime with milliseconds. I created a query to call a view that returns it, but the handler gets the value as with just seconds, even though the same query in SSMS returns milliseconds. Is there a trick to get the toolstep to assign the value with milliseconds?
cheers
Tony

------------------------------
Tony Curoso
American Telesource, Inc.
------------------------------

Steve, 
That makes sense. I had the idea that I was running into a limitation but could not get Genesys support to confirm. 
Thanks for your help.

------------------------------
Tony Curoso
American Telesource, Inc.
------------------------------

Original Message:
Sent: 04-19-2018 08:48
From: Steve Owen
Subject: sql query to return datetime

Date/Time values in handlers only resolve to seconds. You will need to retrieve the value from the database as a string (create a view to do this), convert the date/time portion to a date/time variable and store the milliseconds in a separate, numeric variable.

------------------------------
Steve Owen
Avtex Solutions

Original Message:
Sent: 04-18-2018 21:34
From: Tony Curoso
Subject: sql query to return datetime

I have a need to get the current datetime with milliseconds. I created a query to call a view that returns it, but the handler gets the value as with just seconds, even though the same query in SSMS returns milliseconds. Is there a trick to get the toolstep to assign the value with milliseconds?
cheers
Tony

------------------------------
Tony Curoso
American Telesource, Inc.
------------------------------