[Openfire-br] Openfire-br Digest, Vol 24, Issue 2
Marcelo Terres
mhterres at gmail.com
Wed Jun 4 16:09:04 BRT 2014
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
>
More information about the Openfire-br
mailing list