[cisco-voip] writing system date time through UCCX

[Anthony Holloway]

I don't believe UCCX supports using MS SQL functions in the DB WRITE step:
i.e., http://msdn.microsoft.com/en-us/library/ms186724.aspx

So, you'll have to generate the timestamp in the script, store it in a
String variable in the correct format, then use the variable substitution
method in your SQL command.

E.g., INSERT INTO call_tracker (caller_id, time_stamp)
VALUES($calling_number, $call_start_time)

How you format the date/time value depends on what data type was used to
create the table field.

E.g., "YYYMMDD HH:MM:SS" versus "Month DD, YYYY HH:MM:SS" versus anything
else

Date and Time types for MS SQL:
http://msdn.microsoft.com/en-us/library/ff848733.aspx

Anthony

On Thu, Oct 27, 2011 at 12:50 AM, shary shary <shaary1 at hotmail.com> wrote:

>  Hi Folks,
> i have an Insert query through which i need to add new row in SQL DB but
> the issue is, i need to insert the system current date and time in data
> field as well using any variable.
>
> regards.
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20111028/97b92fe2/attachment.html>