Mapping a SQL Server datetime field to UCCX variable

[cstcorpsk]

Hi,

     I am working on a UCCX script that queries a SQL Server database to get the account data and it includes the date field.  In the SQL Server the column is a  datetime field and I could not determine to which data type in UCCX , the datetime field can be mapped to? Basically, my goal is to query the database and get the date into a UCCX script variable. Any help in very much appreciated.

Thanks

Suresh

[Leo Salcie Tejeda]

Hi,

You can use String as the data type because maybe between service won't use the same time format.

Regards

Please remember to rate useful posts clicking on the stars below.
Favor calificar todos las respuestas útiles.
___________________________________________
LinkedIn Profile: do.linkedin.com/in/leosalcie

[cstcorpsk]

The String datatype cannot be mapped - it wont show up in the DBGET - Field selection - Local variable field. Thanks for your response.

I  resolved the issue by mapping it to a local variable. I created a java.sql.Timestamp local variable field and mapped the SQL output to that variable in the DBGET step. From there I could get the data into a date type variable easily.

Thanks