[Openfire-br] Openfire-br Digest, Vol 24, Issue 2

Alex Douglas adsjcsp at gmail.com
Thu Jun 5 10:07:59 BRT 2014 

O tipo de tempo usado no banco de dado é TIMESTAMP basta colocar no
comando SQL que ele te trás a hora e a data sem problema algum.
Dá uma olhada aí:
http://dev.mysql.com/doc/refman/5.6/en/datetime.html



Em 04/06/14, Marcelo Terres<mhterres at gmail.com> escreveu:
> Ok, então é no formato de timestamp.
>
> Era isso que eu queria saber :-)
>
> []s
> Marcelo H. Terres
> mhterres at gmail.com
> http://mundoopensource.blogspot.com
> http://biertasters.blogspot.com
> http://twitter.com/mhterres
>
>
> 2014-06-04 15:34 GMT-03:00 Jacques de Beijer
> <jacques.beijer at unimedbelem.com.br>:
>> Meus 0,2 cents
>>
>> A data está no tipo de dados bigint. Que é a quantidade de segundos desde
>> 01-01-1970 ou 12-31-1969, não lembro.
>>
>> A data não é louca, nem é do java. UHHuahuauhahu
>> Muitos sistemas usam este tipo de data, o log do squid por exemplo......
>>
>>
>> Aqui eu uso isso no sql server. Veja se te ajuda.
>>
>> set dateformat DMY
>> select top 10 data = dateadd(second, m.sentDate / 1000.00,
>> convert(datetime,
>> '1969-12-31 20:58:53', 121)), *
>> from [dbo].[ofMessageArchive] m(nolock)
>> where  1=1
>> and 'usuario01' in (fromJID, toJID)
>> and 'usuario02' in (fromJID, toJID)
>> and dateadd(second, m.sentDate / 1000.00, convert(datetime, '1969-12-31
>> 20:58:53', 121)) >= '03/06/2014'
>>
>> []'s
>>
>>
>>
>> ________________________________
>> De: "Rui Ornellas Junior" <ruiornellas at gmail.com>
>> Para: openfire-br at listas.softwarelivre.org
>> Enviadas: Quarta-feira, 4 de junho de 2014 14:14:43
>> Assunto: Re: [Openfire-br] Openfire-br Digest, Vol 24, Issue 2
>>
>>
>> Entao ,
>>
>> Marcelo eu estava mostrando a saida de dados para o meu amigo aqui do
>> trabalho ele acabou desenvolvendo uma aplicação em java para fazer a
>> conversao, pelo que eu entendi o java grava no banco de dados em um
>> formato
>> de data e hora diferenciado, eu consegui retirar os relatorios full de
>> conversas do openfire
>>
>>
>>
>> Em 4 de junho de 2014 12:00,
>> <openfire-br-request at listas.softwarelivre.org>
>> escreveu:
>>>
>>> Send Openfire-br mailing list submissions to
>>>         openfire-br at listas.softwarelivre.org
>>>
>>> To subscribe or unsubscribe via the World Wide Web, visit
>>>
>>> http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>>> or, via email, send a message with subject or body 'help' to
>>>         openfire-br-request at listas.softwarelivre.org
>>>
>>> You can reach the person managing the list at
>>>         openfire-br-owner at listas.softwarelivre.org
>>>
>>> When replying, please edit your Subject line so it is more specific
>>> than "Re: Contents of Openfire-br digest..."
>>>
>>>
>>> Today's Topics:
>>>
>>>    1. Re: Openfire-br Digest, Vol 24, Issue 1 (Rui Ornellas Junior)
>>>    2. Re: Openfire-br Digest, Vol 24, Issue 1 (Marcelo Terres)
>>>
>>>
>>> ----------------------------------------------------------------------
>>>
>>> Message: 1
>>> Date: Tue, 3 Jun 2014 12:01:25 -0300
>>> From: Rui Ornellas Junior <ruiornellas at gmail.com>
>>> To: openfire-br at listas.softwarelivre.org
>>> Subject: Re: [Openfire-br] Openfire-br Digest, Vol 24, Issue 1
>>> Message-ID:
>>>
>>> <CAKJbLe4MZXpsePeQQdMdZPPnV+nMMAykdYV7PH3YXEcMgOsbng at mail.gmail.com>
>>> Content-Type: text/plain; charset="utf-8"
>>>
>>> Marcelo,
>>>
>>> A Saida ? uma data louca do java
>>>
>>>
>>> 2014-06-03 12:00 GMT-03:00
>>> <openfire-br-request at listas.softwarelivre.org>:
>>>
>>> > Send Openfire-br mailing list submissions to
>>> >         openfire-br at listas.softwarelivre.org
>>> >
>>> > To subscribe or unsubscribe via the World Wide Web, visit
>>> >
>>> > http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>>> > or, via email, send a message with subject or body 'help' to
>>> >         openfire-br-request at listas.softwarelivre.org
>>> >
>>> > You can reach the person managing the list at
>>> >         openfire-br-owner at listas.softwarelivre.org
>>> >
>>> > When replying, please edit your Subject line so it is more specific
>>> > than "Re: Contents of Openfire-br digest..."
>>> >
>>> >
>>> > Today's Topics:
>>> >
>>> >    1. OpenFire com MySql (Rui Ornellas Junior)
>>> >    2. Re: OpenFire com MySql (Marcelo Terres)
>>> >
>>> >
>>> > ----------------------------------------------------------------------
>>> >
>>> > Message: 1
>>> > Date: Tue, 3 Jun 2014 10:51:48 -0300
>>> > From: Rui Ornellas Junior <ruiornellas at gmail.com>
>>> > To: openfire-br at listas.softwarelivre.org
>>> > Subject: [Openfire-br] OpenFire com MySql
>>> > Message-ID:
>>> >         <CAKJbLe5kbtLZrPSyk=
>>> > j+87wkffh2wped6oQ0Ua8ENTnkDwOB3Q at mail.gmail.com>
>>> > Content-Type: text/plain; charset="utf-8"
>>> >
>>> > Pessoal bom dia,
>>> >
>>> > Preciso de uma ajuda urgente, eu estou com a necessidade de extrair
>>> > algumas
>>> > conversas de um colaborador especifico de minha empresa.
>>> > O Problema ? o seguinte com a ferramenta do Openfire que gera as
>>> > conversas
>>> > em PDF fica praticamente imposs?vel de analisar uma conversa dentro e
>>> > um
>>> > per?odo grande fica muito ruim pois s?o gerados varios arquivos pdf. A
>>> > solu??o ? extrair diretamente do banco porem eu n?o tenho conhecimento
>>> > para
>>> > extrair do banco de dados do MySql, eu tenho tentado e quando faz os
>>> > selects a data da conversa n?o sai no formato correto, sai em um
>>> > formato
>>> > ruim
>>> > -------------- next part --------------
>>> > An HTML attachment was scrubbed...
>>> > URL: <
>>> >
>>> > http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20140603/08ffd6e6/attachment-0001.html
>>> > >
>>> >
>>> > ------------------------------
>>> >
>>> > Message: 2
>>> > Date: Tue, 3 Jun 2014 11:02:36 -0300
>>> > From: Marcelo Terres <mhterres at gmail.com>
>>> > To: Openfire-BR list <openfire-br at listas.softwarelivre.org>
>>> > Subject: Re: [Openfire-br] OpenFire com MySql
>>> > Message-ID:
>>> >         <CAGzWidiA75jr9v9XnacSj8uHza=
>>> > qh-7u_Y2G10VD0Dw1MkbAQQ at mail.gmail.com>
>>> > Content-Type: text/plain; charset=UTF-8
>>> >
>>> > Sai em timestamp ?
>>> > Marcelo H. Terres
>>> > mhterres at gmail.com
>>> > http://mundoopensource.blogspot.com
>>> > http://biertasters.blogspot.com
>>> > http://twitter.com/mhterres
>>> >
>>> >
>>> > 2014-06-03 10:51 GMT-03:00 Rui Ornellas Junior <ruiornellas at gmail.com>:
>>> > > Pessoal bom dia,
>>> > >
>>> > > Preciso de uma ajuda urgente, eu estou com a necessidade de extrair
>>> > algumas
>>> > > conversas de um colaborador especifico de minha empresa.
>>> > > O Problema ? o seguinte com a ferramenta do Openfire que gera as
>>> > conversas
>>> > > em PDF fica praticamente imposs?vel de analisar uma conversa dentro e
>>> > > um
>>> > > per?odo grande fica muito ruim pois s?o gerados varios arquivos pdf.
>>> > > A
>>> > > solu??o ? extrair diretamente do banco porem eu n?o tenho
>>> > > conhecimento
>>> > para
>>> > > extrair do banco de dados do MySql, eu tenho tentado e quando faz os
>>> > selects
>>> > > a data da conversa n?o sai no formato correto, sai em um formato ruim
>>> > >
>>> > > _______________________________________________
>>> > > Openfire-br mailing list
>>> > > Openfire-br at listas.softwarelivre.org
>>> > > Para sair da lista ou alterar suas op??es acesse
>>> > > http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>>> > >
>>> >
>>> >
>>> > ------------------------------
>>> >
>>> > _______________________________________________
>>> > Openfire-br mailing list
>>> > Openfire-br at listas.softwarelivre.org
>>> > http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>>> >
>>> >
>>> > End of Openfire-br Digest, Vol 24, Issue 1
>>> > ******************************************
>>> >
>>> -------------- next part --------------
>>> An HTML attachment was scrubbed...
>>> URL:
>>> <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20140603/9363eeca/attachment-0001.html>
>>>
>>> ------------------------------
>>>
>>> Message: 2
>>> Date: Tue, 3 Jun 2014 12:05:37 -0300
>>> From: Marcelo Terres <mhterres at gmail.com>
>>> To: Openfire-BR list <openfire-br at listas.softwarelivre.org>
>>> Subject: Re: [Openfire-br] Openfire-br Digest, Vol 24, Issue 1
>>> Message-ID:
>>>
>>> <CAGzWidjYrPWeYiwQ8g6j56yvJ4j+Ofv2fBxq6yU4A8-ubbm7Gw at mail.gmail.com>
>>> Content-Type: text/plain; charset=UTF-8
>>>
>>> Pode postar aqui?
>>>
>>> []s
>>> Marcelo H. Terres
>>> mhterres at gmail.com
>>> http://mundoopensource.blogspot.com
>>> http://biertasters.blogspot.com
>>> http://twitter.com/mhterres
>>>
>>>
>>> 2014-06-03 12:01 GMT-03:00 Rui Ornellas Junior <ruiornellas at gmail.com>:
>>> > Marcelo,
>>> >
>>> > A Saida ? uma data louca do java
>>> >
>>> >
>>> > 2014-06-03 12:00 GMT-03:00
>>> > <openfire-br-request at listas.softwarelivre.org>:
>>> >>
>>> >> Send Openfire-br mailing list submissions to
>>> >>         openfire-br at listas.softwarelivre.org
>>> >>
>>> >> To subscribe or unsubscribe via the World Wide Web, visit
>>> >>
>>> >> http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>>> >> or, via email, send a message with subject or body 'help' to
>>> >>         openfire-br-request at listas.softwarelivre.org
>>> >>
>>> >> You can reach the person managing the list at
>>> >>         openfire-br-owner at listas.softwarelivre.org
>>> >>
>>> >> When replying, please edit your Subject line so it is more specific
>>> >> than "Re: Contents of Openfire-br digest..."
>>> >>
>>> >>
>>> >> Today's Topics:
>>> >>
>>> >>    1. OpenFire com MySql (Rui Ornellas Junior)
>>> >>    2. Re: OpenFire com MySql (Marcelo Terres)
>>> >>
>>> >>
>>> >> ----------------------------------------------------------------------
>>> >>
>>> >> Message: 1
>>> >> Date: Tue, 3 Jun 2014 10:51:48 -0300
>>> >> From: Rui Ornellas Junior <ruiornellas at gmail.com>
>>> >> To: openfire-br at listas.softwarelivre.org
>>> >> Subject: [Openfire-br] OpenFire com MySql
>>> >> Message-ID:
>>> >>
>>> >> <CAKJbLe5kbtLZrPSyk=j+87wkffh2wped6oQ0Ua8ENTnkDwOB3Q at mail.gmail.com>
>>> >> Content-Type: text/plain; charset="utf-8"
>>> >>
>>> >> Pessoal bom dia,
>>> >>
>>> >> Preciso de uma ajuda urgente, eu estou com a necessidade de extrair
>>> >> algumas
>>> >> conversas de um colaborador especifico de minha empresa.
>>> >> O Problema ? o seguinte com a ferramenta do Openfire que gera as
>>> >> conversas
>>> >> em PDF fica praticamente imposs?vel de analisar uma conversa dentro e
>>> >> um
>>> >> per?odo grande fica muito ruim pois s?o gerados varios arquivos pdf. A
>>> >> solu??o ? extrair diretamente do banco porem eu n?o tenho conhecimento
>>> >> para
>>> >> extrair do banco de dados do MySql, eu tenho tentado e quando faz os
>>> >> selects a data da conversa n?o sai no formato correto, sai em um
>>> >> formato
>>> >> ruim
>>> >> -------------- next part --------------
>>> >> An HTML attachment was scrubbed...
>>> >> URL:
>>> >>
>>> >> <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20140603/08ffd6e6/attachment-0001.html>
>>> >>
>>> >> ------------------------------
>>> >>
>>> >> Message: 2
>>> >> Date: Tue, 3 Jun 2014 11:02:36 -0300
>>> >> From: Marcelo Terres <mhterres at gmail.com>
>>> >> To: Openfire-BR list <openfire-br at listas.softwarelivre.org>
>>> >> Subject: Re: [Openfire-br] OpenFire com MySql
>>> >> Message-ID:
>>> >>
>>> >> <CAGzWidiA75jr9v9XnacSj8uHza=qh-7u_Y2G10VD0Dw1MkbAQQ at mail.gmail.com>
>>> >> Content-Type: text/plain; charset=UTF-8
>>> >>
>>> >> Sai em timestamp ?
>>> >> Marcelo H. Terres
>>> >> mhterres at gmail.com
>>> >> http://mundoopensource.blogspot.com
>>> >> http://biertasters.blogspot.com
>>> >> http://twitter.com/mhterres
>>> >>
>>> >>
>>> >> 2014-06-03 10:51 GMT-03:00 Rui Ornellas Junior
>>> >> <ruiornellas at gmail.com>:
>>> >> > Pessoal bom dia,
>>> >> >
>>> >> > Preciso de uma ajuda urgente, eu estou com a necessidade de extrair
>>> >> > algumas
>>> >> > conversas de um colaborador especifico de minha empresa.
>>> >> > O Problema ? o seguinte com a ferramenta do Openfire que gera as
>>> >> > conversas
>>> >> > em PDF fica praticamente imposs?vel de analisar uma conversa dentro
>>> >> > e
>>> >> > um
>>> >> > per?odo grande fica muito ruim pois s?o gerados varios arquivos pdf.
>>> >> > A
>>> >> > solu??o ? extrair diretamente do banco porem eu n?o tenho
>>> >> > conhecimento
>>> >> > para
>>> >> > extrair do banco de dados do MySql, eu tenho tentado e quando faz os
>>> >> > selects
>>> >> > a data da conversa n?o sai no formato correto, sai em um formato
>>> >> > ruim
>>> >> >
>>> >> > _______________________________________________
>>> >> > Openfire-br mailing list
>>> >> > Openfire-br at listas.softwarelivre.org
>>> >> > Para sair da lista ou alterar suas op??es acesse
>>> >> > http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>>> >> >
>>> >>
>>> >>
>>> >> ------------------------------
>>> >>
>>> >> _______________________________________________
>>> >> Openfire-br mailing list
>>> >> Openfire-br at listas.softwarelivre.org
>>> >> http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>>> >>
>>> >>
>>> >> End of Openfire-br Digest, Vol 24, Issue 1
>>> >> ******************************************
>>> >
>>> >
>>> >
>>> > _______________________________________________
>>> > Openfire-br mailing list
>>> > Openfire-br at listas.softwarelivre.org
>>> > Para sair da lista ou alterar suas op??es acesse
>>> > http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>>> >
>>>
>>>
>>> ------------------------------
>>>
>>> _______________________________________________
>>> Openfire-br mailing list
>>> Openfire-br at listas.softwarelivre.org
>>> http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>>>
>>>
>>> End of Openfire-br Digest, Vol 24, Issue 2
>>> ******************************************
>>
>>
>>
>> _______________________________________________
>> Openfire-br mailing list
>> Openfire-br at listas.softwarelivre.org
>> Para sair da lista ou alterar suas op��es acesse
>> http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>>
>>
>> _______________________________________________
>> Openfire-br mailing list
>> Openfire-br at listas.softwarelivre.org
>> Para sair da lista ou alterar suas opções acesse
>> http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>>
> _______________________________________________
> Openfire-br mailing list
> Openfire-br at listas.softwarelivre.org
> Para sair da lista ou alterar suas opes acesse
> http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>


-- 



Grato.*

*
*Imprima este e-mail somente se houver necessidade... Cuide da Natureza! *
*Alex Douglas *(TIM) (11)8570-4410
adsjcsp at gmail.com - www.facebook.com/adsjcsp -
www.twitter.com/adsjcsp<http://www.twitter.com/adsjcsp>

More information about the Openfire-br mailing list