Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ShahbazovT
Contributor III
Contributor III
‎2020-11-16 08:40 AM

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)
Labels
Preview file
11 KB
797 Views
0 Likes
3 Replies
dplr-rn
Partner - Master III
Partner - Master III
‎2020-11-16 09:47 AM

try this

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

786 Views
Anil_Babu_Samineni
MVP
MVP
‎2020-11-16 11:58 AM

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
753 Views
0 Likes
ShahbazovT
Contributor III
Contributor III
‎2020-11-17 05:04 AM
Author

Thanks🙏

728 Views
0 Likes