Dates in text format - sql query connection.

Question

team good morning, I have problems with the dates of several sql tables already nourished information which needs to be changed to date format.they are displayed as follows:20211125111517346understanding that it would be the date plus the hour minutes seconds and milliseconds. Anyone know how to fix it? since from powerbi does not let me change the format because I am in query mode. would be of great help.

amitchandak · Answer

Syndicate_Admin , if you using direct query my advice would be create a view and bring date and time from the database or write SQL if allowed in connection&nbsp; 
&nbsp;

syndicate_admin · Answer

Thanks for the reply,The problem is that I have access to the tables from PowerBI, but I do not have write access, I could see that the field is text, you can see that the date impacts from a Now() (it seems to me) since when impacting it is only text and in the following format with milliseconds:20211125111517346

anonymous · Answer

HI&nbsp;Anonymous,
I'd like to suggest you do these in t-sql query(e.g. left, right function) to extract the date and time part then transfer data types:
LEFT (Transact-SQL) - SQL Server | Microsoft Docs
RIGHT (Transact-SQL) - SQL Server | Microsoft Docs
BTW, the current power bi seems not support the millisecond(power bi data model table time values are ended to the second level), if you want to keep these values, you may need to create a new column to store them.
Regards,
Xiaoxin Sheng

Forum Discussion

Related content

Date format issue

DAX Query Format Date

Date formatting

Date Display Formats

Date Format