para que este datetime é usado na consulta de banco de dados [closed]

0

Eu vejo uma consulta do banco de dados

@retVal = (DATEDIFF (s, '19700101', GETUTCDATE ()) - dateTime)

para que esse datetime foi usado ?? n o que esta consulta retorna

    
por Vikram Singh 27.08.2014 / 16:23

1 resposta

1

Se entendi bem sua pergunta, o número 19700101 é Unix Time Stamp

Convertido, aponta para Mon, 17 Aug 1970 00:15:01 GMT: link

The unix time stamp is a way to track time as a running total of seconds. This count starts at the Unix Epoch on January 1st, 1970 at UTC. Therefore, the unix time stamp is merely the number of seconds between a particular date and the Unix Epoch. It should also be pointed out (thanks to the comments from visitors to this site) that this point in time technically does not change no matter where you are located on the globe. This is very useful to computer systems for tracking and sorting dated information in dynamic and distributed applications both online and client side.

    
por 27.08.2014 / 16:36

Tags