Kbase P108886: How the comparison with Date values works on MS SQL Server DataServer?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/05/2010 |
|
Status: Verified
GOAL:
How the comparison with Date values works on MS SQL Server DataServer?
GOAL:
How MS SQL Server DataServer compares datetime and samlldatetime
FACT(s) (Environment):
Windows
MS SQL DataServer
Progress 9.1x
MS SQL DataServer
FIX:
When you create a schema holder from existing SQL Server database, the SQL Server? datetime or smalldatetime data types map to the Progress DATE data type. In this case, Progress truncates the time portion of the date. Therefore, you are not able to compare the time portion of the SQL Server datetime field for the equality match. In the query when you use the *date >= 99/99/99* in the where clause, the time portion is not being supplied to the SQL Server database, hence, the only less than date is being returned from the SQL Server database.