[Openfire-br] Cenário - Opinião

[Carlos Arêdes]

*Segue o Script para conversão no SQL Server:*


*** JavaDate -> Default***
**************************************************************************************
DECLARE @tmp as VARCHAR(15)
SET @tmp = '1324310541917'
SELECT @tmp as JavaTime, CAST((CAST(@tmp AS FLOAT) / 86400000) + 25567 
AS DATETIME)
**************************************************************************************

  *** Defaullt -> JavaDate ***
**************************************************************************************
   DECLARE @dt as DATETIME
   SET @dt = '2011-12-19 16:02:21.917'
   SELECT @dt as SQLTime
     , CAST(DATEDIFF(s, '1970-01-01 00:00:00' , @dt) AS BIGINT)
     + DATEPART(ms, @dt)  as JavaTime
************************************************************************************** 



Em 01/04/2013 15:53, Alex Douglas escreveu:
> Pra dar uma ajudinha:
>
> http://dev.mysql.com/doc/refman/5.0/en/datetime.html
>
>
> 2013/4/1 Marcelo Terres <mhterres at gmail.com <mailto:mhterres at gmail.com>>
>
>     As datas não estão em formato timestamp?
>
>     []s
>     Marcelo H. Terres
>     mhterres at gmail.com <mailto:mhterres at gmail.com>
>     http://mundoopensource.blogspot.com
>     http://biertasters.blogspot.com
>     http://twitter.com/mhterres
>
>
>     2013/4/1 Daniel Gaspary <dgaspary at gmail.com
>     <mailto:dgaspary at gmail.com>>:
>     > 2013/4/1 Carlos Arêdes <carlos.aredes at gmail.com
>     <mailto:carlos.aredes at gmail.com>>:
>     >> Como converter estas datas malucas.
>     >
>     > As datas estão em um formato numérico do java. Então a forma mais
>     > fácil é achar algum aplicativo/plugin ou fazer um, em java, que
>     > converta as datas para formato "humano".
>     > _______________________________________________
>     > Openfire-br mailing list
>     > Openfire-br at listas.softwarelivre.org
>     <mailto:Openfire-br at listas.softwarelivre.org>
>     > http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>     _______________________________________________
>     Openfire-br mailing list
>     Openfire-br at listas.softwarelivre.org
>     <mailto:Openfire-br at listas.softwarelivre.org>
>     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 <mailto:adsjcsp at gmail.com> - 
> www.facebook.com/adsjcsp <http://www.facebook.com/adsjcsp> - 
> www.twitter.com/adsjcsp <http://www.twitter.com/adsjcsp>
>
>
> _______________________________________________
> Openfire-br mailing list
> Openfire-br at listas.softwarelivre.org
> http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20130401/bd108bbb/attachment-0001.html>