Dates and timestamps in qlikview have both a numeric and a text (formatted) value. You can use the date(), time() and timestamp() functions to specify the textual formating. If you're loading a large number of records it's recommended to split the timestamp into separate date and time fields. Qlikview can store these more effeciently because the cardinality of the separate parts is a lot smaller than of the timestamp.
time(frac(MyTimeStamp),'hh:mm:ss') as MyTime,
date(floor(MyTimeStamp),'DD-MM-YYYY') as MyDate