 |
 |
Archives of the TeradataForum
Message Posted: Mon, 16 Jan 2006 @ 16:40:15 GMT
| Subj: | | Re: Time calculations and MLoad |
| |
| From: | | Dieter Noeth |
Simon Bloomer wrote:
| | I have an input field in a multiload which has as a Time field the number of seconds since midnight. ie, 43200 would be 12:00:00pm and
86399 would be 23:59:59. | |
| | I need to convert this to a time that multiload can insert into the target. | |
I didn't test it, but following should work:
time '00:00:00' + (:mycol * interval '00:00:01' hour to second)
Dieter
| |
