Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Data1: 2018-01-17 17:00:00
- Data2: 2018-01-18 10:00:00
- Resultado obtido: 01 17:00:00
- Resultado esperado: 00 17:00:00
- select CAST( '2018-01-01 17:00:01' AS DATETIME ) AS data_um,
- CAST( '2018-01-02 10:01:02' AS DATETIME ) AS data_dois,
- DATEDIFF( SECOND, CAST( '2018-01-01 17:00:01' AS DATETIME ),CAST( '2018-01-02 10:01:02' AS DATETIME ) ) / 60/ 60/ 24 AS difer_dias,
- DATEDIFF( SECOND, CAST( '2018-01-01 17:00:01' AS DATETIME ),CAST( '2018-01-02 10:01:02' AS DATETIME ) ) / 60/ 60 AS difer_horas,
- DATEDIFF( SECOND, CAST( '2018-01-01 17:00:01' AS DATETIME ),CAST( '2018-01-02 10:01:02' AS DATETIME ) ) / 60% 60 AS difer_minutos,
- DATEDIFF( SECOND, CAST( '2018-01-01 17:00:01' AS DATETIME ),CAST( '2018-01-02 10:01:02' AS DATETIME ) ) % 60 AS difer_segundos
Add Comment
Please, Sign In to add comment
