Hi
I have an ODBC connection from our Progress DB into SQL Server 2008.
The connection pulls data from the SQL database for use in the Progress environment.
The field in question is a DATETIME field - i.e. in SQL the format is stored as "25/01/2009 07:20:30"
I use the following progress statement to get this field data:
DISPLAY string(ObjRecordSet:FIELDS("Date"):VALUE).
Where "Date" is the name of the actual field in the SQL DB.
However, when retrieving the date - it only returns the date itself and not the full date and time stamp which I need. i.e. only shows "28/01/20009".
Does anyone know how I can get this to also pull back the time stamp part - im sure im doing something silly but I cant get my head around this.
Many thanks
Ian
I have an ODBC connection from our Progress DB into SQL Server 2008.
The connection pulls data from the SQL database for use in the Progress environment.
The field in question is a DATETIME field - i.e. in SQL the format is stored as "25/01/2009 07:20:30"
I use the following progress statement to get this field data:
DISPLAY string(ObjRecordSet:FIELDS("Date"):VALUE).
Where "Date" is the name of the actual field in the SQL DB.
However, when retrieving the date - it only returns the date itself and not the full date and time stamp which I need. i.e. only shows "28/01/20009".
Does anyone know how I can get this to also pull back the time stamp part - im sure im doing something silly but I cant get my head around this.
Many thanks
Ian