topic Re: Date Format in App Development

Date Format

ShahbazovT — Fri, 02 Apr 2021 08:43:07 GMT

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 — Mon, 16 Nov 2020 14:47:39 GMT

try this

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

Anil_Babu_Samineni — Mon, 16 Nov 2020 16:58:21 GMT

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

ShahbazovT — Tue, 17 Nov 2020 10:04:29 GMT

Thanks🙏