<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.5512" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=437134510-31102011><FONT face=Arial
color=#0000ff size=2>Hi,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=437134510-31102011><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=437134510-31102011><FONT face=Arial
color=#0000ff size=2>GetDate() returns the current SQL server date/time object,
if it helps.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=437134510-31102011><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=437134510-31102011><FONT face=Arial
color=#0000ff size=2>Ian</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] <B>On Behalf Of </B>Anthony
Holloway<BR><B>Sent:</B> 29 October 2011 04:03<BR><B>To:</B> shary
shary<BR><B>Cc:</B> cisco-voip@puck.nether.net<BR><B>Subject:</B> Re:
[cisco-voip] writing system date time through UCCX<BR></FONT><BR></DIV>
<DIV></DIV>I don't believe UCCX supports using MS SQL functions in the DB WRITE
step: i.e., <A
href="http://msdn.microsoft.com/en-us/library/ms186724.aspx">http://msdn.microsoft.com/en-us/library/ms186724.aspx</A>
<DIV><BR></DIV>
<DIV>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.</DIV>
<DIV><BR></DIV>
<DIV>E.g., INSERT INTO call_tracker (caller_id, time_stamp)
VALUES($calling_number, $call_start_time)</DIV>
<DIV><BR></DIV>
<DIV>How you format the date/time value depends on what data type was used to
create the table field.</DIV>
<DIV><BR></DIV>
<DIV>E.g., "YYYMMDD HH:MM:SS" versus "Month DD, YYYY HH:MM:SS" versus anything
else</DIV>
<DIV><BR></DIV>
<DIV>Date and Time types for MS SQL: <A
href="http://msdn.microsoft.com/en-us/library/ff848733.aspx">http://msdn.microsoft.com/en-us/library/ff848733.aspx</A></DIV>
<DIV><BR></DIV>
<DIV>Anthony<BR><BR>
<DIV class=gmail_quote>On Thu, Oct 27, 2011 at 12:50 AM, shary shary <SPAN
dir=ltr><<A
href="mailto:shaary1@hotmail.com">shaary1@hotmail.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV>
<DIV dir=ltr>Hi Folks,<BR>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.<BR> <BR>regards.<BR></DIV></DIV><BR>_______________________________________________<BR>cisco-voip
mailing list<BR><A
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A><BR><A
href="https://puck.nether.net/mailman/listinfo/cisco-voip"
target=_blank>https://puck.nether.net/mailman/listinfo/cisco-voip</A><BR><BR></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>