topic Re: Need date from time stap in App Development

Need date from time stap

Sra1bandi — Thu, 06 Oct 2022 15:51:05 GMT

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.

Re: Need date from time stap

RsQK — Thu, 06 Oct 2022 16:07:01 GMT

Hi, try this:

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

Re: Need date from time stap

sidhiq91 — Thu, 06 Oct 2022 16:40:45 GMT

@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;

Re: Need date from time stap

MarcoWedel — Thu, 06 Oct 2022 19:51:00 GMT

https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunctions/dayname.htm#:~:text=dayname(%2725/01/2013%2016%3A45%3A00%27),Returns%2025/01/2013.