[cisco-voip] How to set Date Format in UCCX for SQL

[Anthony Holloway]

Shary,

Would this work for you?
http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Date.html

The way you create this type of variable is simple.  You know how when you
create a new Date variable, you select Date from the drop downlist, or
maybe type it in directly?  Well, with this new type, you have to type it
in once, just the first time, then subsequent times you will be able to
select it from the drop down.

Could you try this:

1. Keep your current Date variable
2. Make a new variable of type java.sql.Date setting its initial value to
null
3. Just before writing to the DB, use a Set step to cast the Date variable
to your new java.sql.Date variable
4. Use the new java.sql.Date variable in your DB step

I haven't tested this, so I'm not sure if it will get you where you need to
be, but it's a start.

It's hard not having my own private lab setup anymore. =(

Anthony

On Mon, Nov 14, 2011 at 8:56 AM, shary shary <shaary1 at hotmail.com> wrote:

>  Having another challenge, i am getting UCCX current date using D[now] but
> need to forward this date to SQL through Write Query and the format i have
> through D[now] doesn't work with SQL so i need to change this format to SQL
> Format and then need to store in some variable so i can push the date
> towards SQL DB. I am stuck to make format or equation, appreciate any quick
> response.
>
>
> 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/20111114/0c763624/attachment.html>