Kbase P111646: Not getting the entire value from a datetime or smalldatetime data type from MS SQL server using ADO
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/8/2005 |
|
Status: Unverified
SYMPTOM(s):
Not getting the entire value from a datetime or smalldatetime data type from MS SQL server using ADO
Retreiving the column of datetime data type returns only date portion when using ADO access to MS SQL database
FIX:
Convert the datetime data type column into the varchar before assigning its value to the 4GL variable.
For the SQL statement that needs to retrieve the datetime data type column called orderdate :
SELECT orderdate FROM order;
replace it with:
SELECT CONVERT(varchar(25), orderdate, 121) FROM order;