Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ShahbazovT
Contributor III
Contributor III

Date Format

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

 

Labels (1)
3 Replies
dplr-rn
Partner - Master III
Partner - Master III

try this

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

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ShahbazovT
Contributor III
Contributor III
Author

Thanks🙏