#x27;Greenwich'),
> 'MM/DD/ TZH:TZM');
> Seconds := (((dte1-0) - (dte2-0)) * 86400);
> RETURN Seconds;
> END To_Epoch;
> /
>
> Fred
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@ars
2 := TO_TIMESTAMP_TZ('01/01/1970 '|| TZ_Offset('Greenwich'),
> 'MM/DD/ TZH:TZM');
> Seconds := (((dte1-0) - (dte2-0)) * 86400);
> RETURN Seconds;
> END To_Epoch;
> /
>
> Fred
>
> -Original Message-
> From: Action Request System
; Seconds := (((dte1-0) - (dte2-0)) * 86400);
> RETURN Seconds;
> END To_Epoch;
> /
>
> Fred
>
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
> Sent: Monday, August 24, 2009 10
27;), 'MM/DD/
TZH:TZM');
Seconds := (((dte1-0) - (dte2-0)) * 86400);
RETURN Seconds;
END To_Epoch;
/
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
Sent: Monday, August 24, 2009 10
>> SQL Server database, log in as a user who has write access to the AR
>> System
>> tables.
>> 2 Type the following command:
>> % select dateadd(second, C + ,
>> "Jan 1, 1970") from T
>> where, is the number of the column for the date and
ect dateadd(second, C + ,
> "Jan 1, 1970") from T
> where, is the number of the column for the date and time
> field, is the number of the form table, and is a
> positive or negative number representing the number of seconds later or
> earlier than GMT.
> 3 Optio
the form table, and is a
> positive or negative number representing the number of seconds later or
> earlier than GMT.
> 3 Optionally, you could format the date field by using the convert
> function.
> There are 12 different formats from which you can choose. See your
> Sybase
&
ally, you could format the date field by using the convert
function.
There are 12 different formats from which you can choose. See your
Sybase
documentation.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@ars
inal Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa
Sent: Tuesday, August 18, 2009 12:26 PM
To: arslist@ARSLIST.ORG
Subject: Re: Date Time Conversion Issue in Remedy
Thanks again Fred
When the date/time gets updated in
ction Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Tuesday, August 18, 2009 1:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Date Time Conversion Issue in Remedy
I forgot to add ... If you want to know what time zones your Oracle has you can
, August 18, 2009 1:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: Date Time Conversion Issue in Remedy
**
Lisa,
We ended up writing an Oracle function to generate the conversion for us. I
have included the SQL source below. You'll obviously want to change your time
zone and input date f
System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa
Sent: Tuesday, August 18, 2009 12:52
To: arslist@ARSLIST.ORG
Subject: Re: Date Time Conversion Issue in Remedy
**
I'm having a similar issues (details are a little bit different), but how do
you convert a MM/DD/
Fred,
Thanks so much!!
Lisa
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Tuesday, August 18, 2009 1:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: Date Time Conversion Issue in Remedy
Here are
Behalf Of Grooms, Frederick W
Sent: Tuesday, August 18, 2009 12:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: Date Time Conversion Issue in Remedy
Here are my Oracle functions to do the conversion. Change the 'US/Central' to
the time zone your database is using. The nice thing about using Or
27;), 'MM/DD/
TZH:TZM');
Seconds := (((dte1-0) - (dte2-0)) * 86400);
RETURN Seconds;
END To_Epoch;
/
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa
Sent: Tuesday, August 18, 2009 1
...
Lisa
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Robert Halstead
Sent: Tuesday, August 04, 2009 4:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Date Time Conversion Issue in Remedy
** In the database, Remedy
Hello,
It was a small configuration issue with the XML Gateway, I think. Converting
dates to strings and back to numerics is always problematic. I hadn't
noticed the arslist post given I got a support mail directly. Thanks for
your thoughts :)
John
BHOSALE
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Tuesday, August 04, 2009 3:14 PM
Subject: Date Time Conversion Issue in Remedy
** Hi All,
I have an issue in conversion of Date Time Format which is retrieved by
calling a stored Procedure from other
In the database, Remedy stores all date's in integer format (epoch unix
time). Perhaps this is your issue? If you are putting these records
directly into the database without going through remedy then you need to use
epoch time. If you are going through remedy, then I believe its the locale
of t
Hi Amey,
In Remedy, Date field stores internally in database as an integer format.
And its count seconds from January 1, 1970.
So, while you are sending data from other database, first convert your date
in to integer. and then map with remedy date fields.
For testing purpose, just send some inte
Hi All,
I have an issue in conversion of Date Time Format which is retrieved by
calling a stored Procedure from other Database into Remedy
So the workflow is there an Filter which has Set Field Action consisting of
Webservice where the input and Output Parameters are mapped.So this
webservice runs
Hi All,
I have an issue in conversion of Date Time Format which is retrieved by
calling a stored Procedure from other Database into Remedy
So the workflow is there an Filter which has Set Field Action consisting of
Webservice where the input and Output Parameters are mapped.So this
webservice runs
22 matches
Mail list logo
