Date Format

[ShahbazovT]

Hi Experts,

I have a sql script, on that script I want to change format of my Date.

My date format 2020-02-27 00:00:00.000000

I want to delete zeros. Help pls

Screenshot attached

[dplr-rn]

try this

Date(floor(DATE_FIELD), 'YYYY-MM-DD') as Date_Field

[Anil_Babu_Samineni]

=Date(ConvertToLocalTime('2020-02-27 00:00:00.000000'))

[ShahbazovT]

Thanks🙏