Forum Discussion
Change datetime format to date in SQL
Hi, I was trying to change the datetime format to date in the SQL statement in order to lessen the M query due to connecting to a huge database. Here is my code: convert(date, createTime, 101), ...
The createtime column is in datetime format.
Only the cast(createtime as date) works for me. The result is in the format of datetime too.
Is that possible to direct convert it to date format without using query M?
The createtime column is in datetime format.
Only the cast(createtime as date) works for me. The result is in the format of datetime too.
Is that possible to direct convert it to date format without using query M?
Date format is DateTime only set to midnight.