( CAST( x AS DATE ) - CAST( y AS DATE ) ) * 86400
# suiteanalytics
k
( CAST( x AS DATE ) - CAST( y AS DATE ) ) * 86400