Hi there! can anyone help me out I need to compare a date from the database and the system date which will be coded in a store procedure in SQL... HELP!!!!!
SQL comparison
Hot Topic
- A data source instance has not been supplied for the data source
- supressing multiple data items on a report...
- Kick all Users?
- How to uninstall SQL Express Reporting Services without uninstalling the database engine?
- SQL_SSMEE Failed and trying to repair while lauching our mobile client application.
- ReportItems in Page Header
- Cell Calculation for cells that already has values
- How to kill running query?
- How cany I publish 1 table from an attached database?
- VS 2005 standard prevents using free SQL Express functionality?
SQL Server
- ole db source query assistance requested
- KPI Annotations property field
- Extract data from ACCESS database with pwd via ODBC
- Amazon Web Service Call with Web Service Task
- Exporting data to a fixed-width flat file
- Server Broker Contract talking to Multiple Computers
- checking report expression syntax
- Comparing DateTime to UK Format
- Access shared data source inside custom assembly
- Complicated join question.
SQL comparison
Rozee
You may like to reconsider the answer given by Ali. DateTimes in NET are stored to a precision of 100 ns or 0.0000001 seconds whilst those stored by SQL Server in the SQL Server datatype DateTime are stored to the nearest 0.003333 seconds. Therefore you should not use a simple equality operator to compare them. Instead you should compare them based on the lowest precision argument, ie round the NET DateTime to the nearest 0.00333 seconds and then compare them.
Regards,
John Whattam.
Sorcerer14
wakjah
You can use the DATEADD function with this syntax
DATEADD ( datepart , number, date )
Daniel Coleman