Visibility of Date & Time from External MSSQL BO

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
customaware
Posts: 2391
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Visibility of Date & Time from External MSSQL BO

Post by customaware »

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?
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
UnionSystems
Posts: 197
Joined: Fri Jun 17, 2016 7:10 am
Location: Brisbane Australia
Contact:

Re: Visibility of Date & Time from External MSSQL BO

Post by UnionSystems »

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.
AWS Linux, Windows Server, AIM 8.4 & 8.6
Post Reply