Hi Lisa
The database reference guide has the information for going from EPOCH
date to the date in a format you require (in 6.3 it was p.54 - see below
signature)
SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/YYYY
HH24:MI:SS') +
((C<column_number> +
<offset>)/(60*60*24)),'MM/DD/YYYY HH24:MI:SS') FROM T<table_number>;
Going the other way (subtract epoch from current stamp to get difference
in seconds)
select to_date('2008-07-16','yyyy-mm-dd') -
to_date('1970-01-01','yyyy-mm-dd') from dual
regards
Dave Morgan
Converting AR System dates to database dates
AR System keeps track of the date and time to run escalations, stamps
requests with the date and time they were submitted, and informs you
when
alerts were sent. To track the date and time, AR System uses a format
that
measures the number of seconds from January 1, 1970, 12:00 a.m.
Greenwich
Mean Time (GMT). While accurate, this format can be an awkward format
to read. You might want to translate it to a format that your database
can
easily read.
Each database requires different commands for the date and time
conversion. The following procedures describe how you can use your
database to convert the AR System date and time format.
Note: In the SQL commands in the following procedures, the column
number is referenced by <column_number>. Alternatively, you can
provide the SQL view name of the column (the database name of the field
as displayed in Remedy Administrator).
" To convert the date and time format for a DB2 Universal database:
" See your DB2 documentation for information about dateline arithmetic.
" To convert the date and time format for an Informix database:
1 Using any front-end tool that allows direct access to an Informix-SQL
database, log in as the root user.
2 Type the following command:
% select (extend((extend(datetime(1970-1-1) year to day, year to hour) -
interval(<offset_hours>) hour to hour), year to second) +
C<column_number>
units second) from T<table_number>
where, <column_number> is the number of the column for the date and time
field, <table_number> is the number of the form table, and
<offset_hours> is
a positive or negative number representing the number of hours later or
earlier than GMT.
If the date is greater than 09/10/2001, you will receive an error. To
avoid an
error, you can display minutes instead of seconds by using the following
command:
% select (extend((extend(datetime(1970-1-1) year to day, year to hour) -
interval(<offset_hours>) hour to hour), year to minute)
+(C<column_number>/60)
units minute) from T<table_number>
See the Informix Guide to SQL: Reference and Syntax manaul for
information
about the datetime, extend, and interval functions.
" To convert the date and time format for an Oracle database:
1 Using any front-end tool that enables direct access to an Oracle SQL
database, log in as a user with write access to the AR System tables.
2 Type the following command:
% SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/YYYY
HH24:MI:SS') + ((C<column_number> + <offset>)/(60*60*24)),
'MM/DD/YYYY HH24:MI:SS') FROM T<table_number>;
where, <column_number> is the number of the column for the date and time
field, <table_number> is the number of the form table, and <offset> is a
positive or negative number representing the number of seconds later or
earlier than GMT.
See the your Oracle documentation for information about the TO_DATE and
TO_CHAR functions.
" To convert the date and time format for a Sybase or Microsoft SQL
Server
database:
1 Using any front-end tool that enables direct access to a Sybase or
Microsoft
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<column_number> + <offset>,
"Jan 1, 1970") from T<table_number>
where, <column_number> is the number of the column for the date and time
field, <table_number> is the number of the form table, and <offset> 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
documentation.
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa
Sent: 18 August 2009 18:24
To: arslist@ARSLIST.ORG
Subject: Re: Date Time Conversion Issue in Remedy
--_000_46CDC1E68702E54387E9EAEDC0A02CA207C87BF0C5us194mx002tyc_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I think this is the function to convert FROM Epoch to a readable
date/time =
format. I need the other way around...
Thanks!
Lisa
________________________________
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslis=
T.ORG] On Behalf Of Cesaro, Tony M[EQ]
Sent: Tuesday, 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 format accordingly.
create or replace FUNCTION GETDATE (a_number number)
RETURN Date IS
date_x date;
BEGIN
if a_number is null then
return null;
else
date_x :=3D new_time(TO_DATE('01/01/1970 00:00:00',
'MM/DD/YYYYHH24:MI=
:SS') + (a_number/86400),'GMT','EDT');
end if;
RETURN(date_x);
END GetDate;
Regards,
Tony Cesaro
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslis=
T.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 d=
o you convert a MM/DD/YYYY HH:MM:SS to epoch time. We are using Windows
20=
03, Oracle 10, ARS 7.0.1....
I've seen lots of info about converting Epoch to a readable date format,
bu=
t not the other way around....
Lisa
________________________________
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslis=
T.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 stores all date's in integer format (epoch
unix =
time). Perhaps this is your issue? If you are putting these records
direc=
tly into the database without going through remedy then you need to use
epo=
ch time. If you are going through remedy, then I believe its the locale
of=
the server but not sure. (MM/DD/YYYY HH:MM:SS)
Hopefully this helps?
On Tue, Aug 4, 2009 at 11:31 AM, AMEY BHOSALE
<ameyb...@gmail.com<mailto:am=
eyb...@gmail.com>> wrote:
** Hi All,
I have an issue in conversion of Date Time Format which is retrieved by
cal=
ling 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
webser=
vice runs on the XMLGATEWAY calling the stored procedure.
There is a form in Remedy which will store the details retrieved from
store=
d procedure.The fields in the form are mapped in Xmlgateway Template
(Creat=
e) and Template (Query).
The Template(Create) will create the record in the Remedy Form with the
Out=
put recieved from the Template(Query) which contains the stored
procedure d=
etails.
So there are there date time fields which are returned by stored
procedure =
having the formats as below : -
Two Date Time fields have format as :- MM/dd/yyyy hh:mm:ss for e.g
4/17/200=
8 12:00:00
One Date Time field has format as :- yyyy/MM/dd hh:mm:ss for e.g
2008/ 4=
/17 12:00:00
So in the Create Template of Xmlgateway i specified the above formats
but w=
hen the record is created in Remedy the other values are captured but
the d=
ate time format fields the value is blank.
When i checked Catalina.out log file found that it is not able to
convert t=
his date format into Remedy.
So can anyone let me know what format of date time needs to be specified
in=
Create Template of Xmlgateway ?
Regards,
Amey Bhosale
_Platinum Sponsor:
rmisoluti...@verizon.net<mailto:rmisoluti...@verizon.net=
> ARSlist: "Where the Answers Are"_
--
"A fool acts, regardless; knowing well that he is wrong. The ignoramus
acts=
on only what he knows, but all that he knows.
The ignoramus may be saved, but the fool knows that he is doomed."
Bob Halstead
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are=
"_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are=
"_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are=
"_
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"
--_000_46CDC1E68702E54387E9EAEDC0A02CA207C87BF0C5us194mx002tyc_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
**
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:v =3D "urn:schemas-microsoft-com:vml" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word" xmlns:m =3D=20
"http://schemas.microsoft.com/office/2004/12/omml";><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html;
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.6000.16890" name=3DGENERATOR></HEAD>
<BODY lang=3DEN-US vLink=3Dpurple link=3Dblue>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D051072317-18082009><FONT
face=3DA=
rial=20
color=3D#000080 size=3D2>I think this is the function to convert FROM
Epoch=
to a=20
readable date/time format. I need the other way=20
around...</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D051072317-18082009><FONT
face=3DA=
rial=20
color=3D#000080 size=3D2><BR>Thanks!</FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=3Den-us><FONT face=3DArial color=3D#000080
size=3D2>Lisa</FON=
T></SPAN>=20
</P>
<DIV> </DIV><BR>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> Action Request System
discussion=
=20
list(ARSList) [mailto:arsl...@arslist.org] <B>On Behalf Of </B>Cesaro,
Tony=
=20
M[EQ]<BR><B>Sent:</B> Tuesday, August 18, 2009 1:01 PM<BR><B>To:</B>=20
arslist@ARSLIST.ORG<BR><B>Subject:</B> Re: Date Time Conversion Issue
in=20
Remedy<BR></FONT><BR></DIV>
<DIV></DIV>**=20
<META content=3D"Microsoft Word 12 (filtered medium)"
name=3DGenerator><!--=
[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New
Roman","seri=
f"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New
Roman","seri=
f"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New
Roman","seri=
f"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority:
99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority:
99
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in;
FONT-FAMILY: "Times =
New Roman","serif"; mso-style-priority: 99; mso-margin-top-alt: auto;
mso-m=
argin-bottom-alt: auto
}
SPAN.EmailStyle18 {
COLOR: #1f497d; FONT-FAMILY: "Calibri","sans-serif";
mso-style-type: perso=
nal-reply
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
<DIV class=3DSection1>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY:
'Calibri','sans-seri=
f'">Lisa,<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY:
'Calibri','sans-seri=
f'"><o:p> </o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY:
'Calibri','sans-seri=
f'">We=20
ended up writing an Oracle function to generate the conversion for
us. =
; I=20
have included the SQL source below. You’ll obviously want to
ch=
ange your=20
time zone and input date format accordingly.<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY:
'Calibri','sans-seri=
f'"><o:p> </o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier
New'">creat=
e or=20
replace FUNCTION GETDATE (a_number number)<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier
New'"> =
;RETURN=20
Date IS<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier
New'"> =
; =20
date_x date;<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier
New'"><o:p>=
</o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier
New'">BEGIN=
<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier
New'"> =
; if=20
a_number is null then<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier
New'"> =
; =20
return null;<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier
New'"> =
;=20
else<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier
New'"> =
; =20
date_x :=3D new_time(TO_DATE('01/01/1970 00:00:00',
'MM/DD/YYYYHH24:MI:SS')=
+=20
(a_number/86400),'GMT','EDT');<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier
New'"> =
; end=20
if;<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier
New'">RETUR=
N(date_x);<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier
New'">END=20
GetDate;<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY:
'Calibri','sans-seri=
f'"><o:p> </o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY:
'Calibri','sans-seri=
f'">Regards,<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY:
'Calibri','sans-seri=
f'"><o:p> </o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY:
'Calibri','sans-seri=
f'">Tony=20
Cesaro<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY:
'Calibri','sans-seri=
f'"><o:p> </o:p></SPAN></P>
<DIV=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP:
#b5c4df=
1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium
non=
e; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=3DMsoNormal><B><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY:
'Tahoma','sans-serif'">From:</SPAN><=
/B><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"> Action
Reque=
st=20
System discussion list(ARSList) [mailto:arsl...@arslist.org] <B>On
Behalf O=
f=20
</B>Kemes, Lisa<BR><B>Sent:</B> Tuesday, August 18, 2009
12:52<BR><B>To:</B=
>=20
arslist@ARSLIST.ORG<BR><B>Subject:</B> Re: Date Time Conversion Issue
in=20
Remedy<o:p></o:p></SPAN></P></DIV>
<P class=3DMsoNormal><o:p> </o:p></P>
<P class=3DMsoNormal>** <o:p></o:p></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY:
'Arial','sans-serif'">I=
'm=20
having a similar issues (details are a little bit different), but how do
yo=
u=20
convert a MM/DD/YYYY HH:MM:SS to epoch time. We are using Windows
200=
3,=20
Oracle 10, ARS 7.0.1....</SPAN><o:p></o:p></P>
<P class=3DMsoNormal> <o:p></o:p></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY:
'Arial','sans-serif'">I=
've=20
seen lots of info about converting Epoch to a readable date format, but
not=
the=20
other way around....</SPAN><o:p></o:p></P>
<DIV>
<P class=3DMsoNormal> <o:p></o:p></P></DIV>
<P><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY:
'Arial','sans-serif'">L=
isa</SPAN>=20
<o:p></o:p></P>
<DIV>
<P class=3DMsoNormal> <o:p></o:p></P></DIV>
<P class=3DMsoNormal><o:p> </o:p></P>
<DIV class=3DMsoNormal style=3D"TEXT-ALIGN: center" align=3Dcenter>
<HR align=3Dcenter width=3D"100%" SIZE=3D2>
</DIV>
<P class=3DMsoNormal style=3D"MARGIN-BOTTOM: 12pt"><B><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY:
'Tahoma','sans-serif'">From:</SPAN><=
/B><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"> Action
Reque=
st=20
System discussion list(ARSList) [mailto:arsl...@arslist.org] <B>On
Behalf O=
f=20
</B>Robert Halstead<BR><B>Sent:</B> Tuesday, August 04, 2009 4:24=20
PM<BR><B>To:</B> arslist@ARSLIST.ORG<BR><B>Subject:</B> Re: Date Time
Conve=
rsion=20
Issue in Remedy</SPAN><o:p></o:p></P>
<P class=3DMsoNormal style=3D"MARGIN-BOTTOM: 12pt">** In the database,
Reme=
dy stores=20
all date's in integer format (epoch unix time). Perhaps this is
your=
=20
issue? If you are putting these records directly into the database
wi=
thout=20
going through remedy then you need to use epoch time. If you are
goin=
g=20
through remedy, then I believe its the locale of the server but not
sure.&n=
bsp;=20
(MM/DD/YYYY HH:MM:SS)<BR><BR>Hopefully this helps?<o:p></o:p></P>
<DIV>
<P class=3DMsoNormal>On Tue, Aug 4, 2009 at 11:31 AM, AMEY BHOSALE
<<A=20
href=3D"mailto:ameyb...@gmail.com";>ameyb...@gmail.com</A>>=20
wrote:<o:p></o:p></P>
<P class=3DMsoNormal>** Hi All, <o:p></o:p></P>
<DIV>
<P class=3DMsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=3DMsoNormal>I have an issue in conversion of Date Time Format
whic=
h is=20
retrieved by calling a stored Procedure from other Database into=20
Remedy<o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=3DMsoNormal>So the workflow is there an Filter which has Set
Field=
Action=20
consisting of Webservice where the input and Output Parameters are
mapped.S=
o=20
this webservice runs on the XMLGATEWAY calling the stored=20
procedure.<o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=3DMsoNormal>There is a form in Remedy which will store the
details=
=20
retrieved from stored procedure.The fields in the form are mapped in
Xmlgat=
eway=20
Template (Create) and Template (Query).<o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=3DMsoNormal>The Template(Create) will create the record in the
Rem=
edy=20
Form with the Output recieved from the Template(Query) which contains
the s=
tored=20
procedure details.<o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=3DMsoNormal>So there are there date time fields which are
returned=
by=20
stored procedure having the formats as below : -<o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=3DMsoNormal>Two Date Time fields have format as :- MM/dd/yyyy
hh:m=
m:ss=20
for e.g 4/17/2008 12:00:00<o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal>One Date Time field has format as :-
yyyy=
/MM/dd=20
hh:mm:ss for e.g 2008/ 4/17 12:00:00<o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=3DMsoNormal>So in the Create Template of Xmlgateway i specified
th=
e above=20
formats but when the record is created in Remedy the other values are
captu=
red=20
but the date time format fields the value is blank.<o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=3DMsoNormal>When i checked Catalina.out log file found that it
is =
not=20
able to convert this date format into Remedy.<o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=3DMsoNormal>So can anyone let me know what format of date time
nee=
ds to=20
be specified in Create Template of Xmlgateway ?<o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=3DMsoNormal>Regards,<o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=3DMsoNormal>Amey Bhosale<o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><o:p> </o:p></P></DIV>
<P class=3DMsoNormal>_Platinum Sponsor: <A
href=3D"mailto:rmisoluti...@veri=
zon.net"=20
target=3D_blank>rmisoluti...@verizon.net</A> ARSlist: "Where the Answers
Ar=
e"_=20
<o:p></o:p></P></DIV>
<P class=3DMsoNormal><BR><BR clear=3Dall><BR>-- <BR>"A fool acts,
regardles=
s;=20
knowing well that he is wrong. The ignoramus acts on only what he knows,
bu=
t all=20
that he knows.<BR>The ignoramus may be saved, but the fool knows that he
is=
=20
doomed."<BR><BR>Bob Halstead<BR>_Platinum Sponsor:
rmisoluti...@verizon.net=
=20
ARSlist: "Where the Answers Are"_ <o:p></o:p></P>
<P class=3DMsoNormal>_Platinum Sponsor: rmisoluti...@verizon.net
ARSlist: "=
Where=20
the Answers Are"_ <o:p></o:p></P></DIV>_Platinum Sponsor:=20
rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
</BODY></HTML>
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_
--_000_46CDC1E68702E54387E9EAEDC0A02CA207C87BF0C5us194mx002tyc_--
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
