General information
Title:
How to calculate the number of days with MS SQL Server?
Environment versions
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only