Can we remove timestamp from time type dimension and return value format as yyyy-mm-dd using MSSQL database.

[Shailendar]

Can we remove timestamp from time type dimension and return value format as yyyy-mm-dd using MSSQL database.

I am using MSSQL for db connection and I have one column which is datetime data type. Now I want to get the column using Cuebjs and I am able to do that. I am using type as time in cubejs. Now my problem is I am always getting timestamp along with date. But I just want date only in yyyy-mm-dd format. Can we do this in MSSQL. I can see the solution for this for BigQuery and mongodb but not for MSSQL. Could you please let me know how to handle this.

Thanks,
Shailendar

[igorlukanin]

Hi @Shailendar 👋

I am always getting timestamp along with date. But I just want date only in yyyy-mm-dd format

Which API do you use? How do you consume the data?

Anyhow, when using the REST API, you should be able to format the date as you need on the client side (example). When using the SQL API with a BI tool, you should be able to format the date on the BI side.

I hope this helps.