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: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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: 
Vijayqliksept12
Contributor
Contributor
‎2021-09-24 05:06 AM

how extract Time and date

Vijayqliksept12_0-1632474223631.png

 

670 Views
0 Likes
2 Replies
MayilVahanan
MVP
MVP
‎2021-09-24 06:14 AM

Hi 

Data looks like , ur fields contains string values. So try like below

Date(floor(Timestamp#(DATETIME , 'DD-MM-YYYY hh:mm:ss'))) as Date

 time(frac(Timestamp#(DATETIME , 'DD-MM-YYYY hh:mm:ss'))) as Time

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
645 Views
Vijayqliksept12
Contributor
Contributor
‎2021-09-24 12:46 PM
Author

thank you

623 Views
0 Likes