Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jabulani
Starting Member
2 Posts |
 Posted - 2011-06-03 : 06:38:13
|
| Qlikview’s timestamp is a real number. The integer is the number of days from a given date (1899-12-30) the remainder is time. It is often necessary to work with the Qlikview timestamp, normally using the time for one purpose or another, so it is necessary to know how to convert time to Qlikview’s timestamp. This is done as follows: To calculate 1 second you simply divide 1 by 24 to give you hours then by 60 to give you minutes and finally by 60 again to give you seconds i.e. 1 / 24 / 60 / 60.Knowing this you are given a timestamp, you are asked to remove 2H30 from the time, and then return only the time (i.e. the remainder) from the real number. Explain how you would do this using basic programming methods.jwmabena |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2011-06-03 : 06:41:56
|
| Exam time is it?Which part are you looking for help on and how far have you gone yourself to trying to solve the question? |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-03 : 06:42:08
|
| Homework?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
help me