Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sra1bandi
Contributor III
Contributor III

Need date from time stap

hi team,

 

i have a date like below

"2019-10-16 13:18:20.000000"

i need it like "16.10.2019" 

i need to this in back end scripting not in front end

 

Regards,

Sra1.

Labels (1)
3 Replies
RsQK
Creator II
Creator II

Hi, try this:

DATE(FLOOR(TIMESTAMP#(timestamp_field,'YYYY-MM-DD hh:mm:ss.ffffff')),'DD.MM.YYYY') AS date_field
sidhiq91
Specialist II
Specialist II

@Sra1bandi  You can try the below script:

NoConcatenate
Temp:
Load DATE(FLOOR(TIMESTAMP#(Timestamp,'YYYY-MM-DD hh:mm:ss.ffffff')),'DD.MM.YYYY') as Date
inline [
Timestamp
2019-10-16 13:18:20.000000
];

Exit Script;