[cisco-voip] writing system date time through UCCX

[Ian Tait]

Hi,
 
GetDate() returns the current SQL server date/time object, if it helps.
 
Ian

________________________________

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Anthony
Holloway
Sent: 29 October 2011 04:03
To: shary shary
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] writing system date time through UCCX


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/20111031/5a0a7326/attachment.html>