Forum Discussion
SQL column as Date type format converting to Date/Time during Query Editor Import
Hi Tgilchrist ,
I found the following answer.
Date format is DateTime only set to midnight.
https://community.powerbi.com/t5/Desktop/Change-datetime-format-to-date-in-SQL/td-p/441602
Hi Tgilchrist
Just curious, why is this such a problem?
anyway, try to play with CAST or CONVERT
I think
CAST(Timestamp as nvarchar(10))
could help you
It's not causing any problems with the report as far as performance or modeling goes, it just seems like a redundant thing to do and I don't have much experience in PowerBi so I was hoping it may be something simple.
just testing a few combinations, It seems like nvarchar is always recognize as Text regardless if the content is in a date format and date is recognized as Date/Time
Hi Tgilchrist ,
I found the following answer.
Date format is DateTime only set to midnight.
https://community.powerbi.com/t5/Desktop/Change-datetime-format-to-date-in-SQL/td-p/441602
This does cause a problem when you want to use the date field with slicers or as values in tables - having the redundant time element is just messy and looks as though you can't be bothered to format properly. Where in reality I can't find a way to format to just date.
