This content has been marked as final. Show 10 replies
I have got data that is structured like this:
As I would like to have the value as DDMMYYYY I try to load the data like this:
ODBC CONNECT32 TO [DWH_P3.world;DBQ=DWH_P3] (XUserId is BQYVFIBHWBMOTcAHbCTCEBdLTKREFLFJDKRGVOVD, XPassword is dUbMAYVMQbcSWYIGTBSB);
SQL SELECT *
This however gives the following:
So the date format seems wrong. Any thoughts on what goes wrong here?