Information générale
Titre:
How to calculate the number of days with MS SQL Server?
Versions des environnements
Network:
Windows 2003 Server
I have a remote view with the following field expression. I am trying to calculate the number of days between the audit start and the current date. This is not returning the number of days however it's returning a datetime value. How can I perform this calculation and have the results listed as a field in the select cursor?
getdate()-Audits.dstart AS no_of_days
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement