Not sure what exactly you are looking for, how you are getting that
data, but if you can use java this may help:
http://arswiki.org/projects/klink/browser/trunk/WEB-INF/src/java/com/kd/klink/ars/util/ArsUtil.java#L106
If you are reporting against a data warehouse, you may consider
parsing the diary fields and storing them in a separate table, with 3
columns - user, datetime, and data. This will make the reporting
easier. It wouldn't be advisable to do this in the application db
though.
The integer date you see if posix time:
http://en.wikipedia.org/wiki/UNIX_time
This article will give you the info you need to convert the data with
whatever means you have available.
Axton Grams
On 4/30/07, Julio Cesar Villarreal Gonzalez
<[EMAIL PROTECTED]> wrote:
Happy Monday listers, my question are the next:
I have a Diary field, but the information is showed in Reporting
Services, in seconds, like a string, my question is:
How can I show this information in Date Format, like appear in
remedy user tool?
I need display this information in the web for my enterprise.
Example:
1177342799.RAUL SANCHEZ.INSTALAR BASE DE DATOS.1177344243.Demo.1
HORAS xx.1177344591.RAUL SANCHEZ.1 HORAS xxx.1177344665.RAUL SANCHEZ.1
HORAS xxxx.1177348153.RAUL SANCHEZ.1 HORAS a.1177350824.RAUL SANCHEZ.1
HORAS B.1177350883.RAUL SANCHEZ.1 HORAS C.1177350955.RAUL SANCHEZ.2
HORAS D.1177352557.RAUL SANCHEZ.2 HORAS E.1177352655.RAUL SANCHEZ.3
HORAS F.1177364526.RAUL SANCHEZ.1 HORAS g.1177364574.RAUL SANCHEZ.1
HORAS h.1177364976.RAUL SANCHEZ.1 HORAS i.1177365034.RAUL SANCHEZ.1
HORAS j.1177365334.RAUL SANCHEZ.1 HORAS k.1177365378.RAUL SANCHEZ.3
HORAS l.1177365445.RAUL SANCHEZ.1 HORAS m.1177365460.RAUL SANCHEZ.1
HORAS n.1177365514.RAUL SANCHEZ.1 HORAS o.1177365535.RAUL SANCHEZ.1
HORAS
Thanks,
Julio Cesar
Remedy 6.3, Solaris, Oracle 10i.
...........................................................................................
Este correo electronico es confidencial y/o puede contener informacion
privilegiada.
Si usted no es su destinatario o no es alguna persona autorizada por este para
recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o
tomar ninguna accion basada en este correo electronico o cualquier otra
informacion incluida en el, favor de notificar al remitente de inmediato
mediante el reenvio de este correo electronico y borrar a continuacion
totalmente este correo electronico y sus anexos.
Nota: Los acentos y caracteres especiales fueron omitidos para su correcta
lectura en cualquier medio electronico.
This e-mail is confidential and/or may contain privileged information.
If you are not the addressee or authorized to receive this for the addressee,
you must not use, copy, disclose, or take any action based on this message or
any
other information herein, please advise the sender immediately by reply this
e-mail and delete this e-mail and its attachments.
...........................................................................................
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
