I have a timestamp field of type 2019-01-01 23:59:59.997 and I need to extract the time from this field but when I try with Timestamp#(MyField, 'YYYY-MM-DD hh:mm:ss.fff') for convert MyField in a number, the result is the same field 2019-01-01 23:59:59.997.
Does anybody knows why is this happening? And how can I solve this issue or if there is other way to extract the time (hh:mm) from this field.
The use of Timestamp#() does not change the displayed format of your field, but if you will get an underlying numeric value that represent that timestamp. When you have this numeric value then you can apply a variety of date and time manipulations to is such as @sunny_talwar solution above.
??? Celebrating my 300 accepted solution in the Qlik Community ???