#unixtimestamp

[raizesvoadoras]

“Você esteve bem perto, ganhou tudo e esteve por muito tempo no topo, mas o seu medo te fez deixar de lado tudo isso.”

Parecia tão incrível, tão intocável... afinal, porquê algo assim aconteceria comigo? o que fiz para merecer?

Não era possível acreditar que poderia dar certo, não poderia ser assim tão fácil, não é mesmo? e por isso foi deixado de lado até que a chama verde se apagasse.

Uma pergunta ainda sem resposta, 24 de Novembro, 2018.

[gamesover2600]

EpochTimeToLocalDate UDF w/Millisecond Support

I needed to convert some Epoch/Unix timestamps (from Ehcache) to date objects. DateAdd() kept throwing an error because it only accepts an integer and the millescond accuracy made the number too big.

“Cannot convert the value 1.426637416706E12 to an integer because it cannot fit inside an integer.”

I was using the EpochTimeToLocalDate UDF to convert timestamps, but it didn't like values with millisecond accuracy. This update provides support for long integers by checking the value to determine if it needs to be divided by 1,000 to have the milliseconds removed.

https://gist.github.com/JamoCA/15e3c3ba0cc855131ca7

NOTE: I encountered issues with "eternal" times with very large integers and had to use the following Java syntax.

theNumber = 1426637416706; theDate = createObject( "java", "java.util.Date" ).init(javacast("long",theNumber));

[jacob-cs]

from_unixtime() converting unix timestamp to mysql timestamp

FROM_UNIXTIME(unix_timestamp), FROM_UNIXTIME(unix_timestamp,format)

Returns a representation of the unix_timestamp argument as a value in 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS.uuuuuu format, depending on whether the function is used in a string or numeric context. The value is expressed in the current time zone. unix_timestamp is an internal timestamp value such as is produced by the UNIX_TIMESTAMP() function.

If format is given, the result is formatted according to the format string, which is used the same way as listed in the entry for the DATE_FORMAT() function.

mysql> SELECT FROM_UNIXTIME(1196440219);         -> '2007-11-30 10:30:19' mysql> SELECT FROM_UNIXTIME(1196440219) + 0;         -> 20071130103019.000000 mysql> SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(),     ->                      '%Y %D %M %h:%i:%s %x');         -> '2007 30th November 10:30:59 2007' Note: If you use UNIX_TIMESTAMP() and FROM_UNIXTIME() to convert between TIMESTAMP values and Unix timestamp values, the conversion is lossy because the mapping is not one-to-one in both directions. For details, see the description of the UNIX_TIMESTAMP() function.