I am accessing tables from an external MSSQL Database.
When I display a Query of that data, I can see everything with the exception of Date and Time columns.
Does anyone know a way to get Aware to recognise those data types from the external table please?
Visibility of Date & Time from External MSSQL BO
-
- Posts: 2413
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Visibility of Date & Time from External MSSQL BO
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
-
- Posts: 197
- Joined: Fri Jun 17, 2016 7:10 am
- Location: Brisbane Australia
- Contact:
Re: Visibility of Date & Time from External MSSQL BO
Hi Mark,
I just got a Facebook Memory come up of the conference in Providence Rhode Island, happy times!
Regards the Date Time issue in SQL, solution might be to format the date or time column to match the format defined in the AwareIM definition of the attribute. In mySql that is something like DATE_FORMAT(myDate, "%d/%M/%Y") if your AwareIM date attribute is formatted dd/MM/yyyy.
I just got a Facebook Memory come up of the conference in Providence Rhode Island, happy times!
Regards the Date Time issue in SQL, solution might be to format the date or time column to match the format defined in the AwareIM definition of the attribute. In mySql that is something like DATE_FORMAT(myDate, "%d/%M/%Y") if your AwareIM date attribute is formatted dd/MM/yyyy.
AWS Linux, Windows Server, AIM 8.4 & 8.6