How to remove timestamp from date columns?

[ShantanuDagar]

Hey all,

I have columns with the following format:

yyyy-mm-dd hh:mm:ss

Want to remove the timestamp while keeping everything else same including format and data type.

Note: Some null values exist in the columns. 

Thanks

[BRRLL99 · Accepted solution]

Use Select Tool and convert date time format into date format

[ShankerV]

Hi @ShantanuDagar 

One way of doing this.

Input was:

Many thanks

Shanker V