---
title: "TOTIME"
description: "TOTIME"
keywords: "TOTIME"
url: "https://myrapidi.com/wiki/totime"
locale: "en"
published: "2009-05-15T09:59:28Z"
modified: "2012-11-08T07:44:13Z"
---

# TOTIME(hour, minute, second);

Totime can be used if you need to transfer hour, minute and seconds to a single field in the destination.

 

**Example:**

> Source holds hours, minutes and seconds in separate fields, and needs to be transferred into a Time field in the destination.
> 
>  
> 
> sHour = 12  
> sMinute= 44  
> sSecond= 23
> 
>  
> 
> ##TOTIME("sHour", "sMinute", "sSecond")  
> Return Value= 12:44:23 as a Time
> 
>  

  **Example of TODATE and COPY:**

> ##TODATE(COPY(Date,6,2),COPY(Date,4,2),COPY(Date,0,4));
> 
>  
> 
> In the source table we have the field "Date" which contains the date format YYYYMMDD (for example: 20090515). The corresponding field in the destination table contains the date format DDMMYYYY.   
> In the source field, Copy will go to position 6 and copy the following two signs (DD - 15) to the destination field. Then it will go to position 4 and copy the following 2 signs (MM - 05). Then it will go to position 0 and copy the following 4 signs (YYYY - 2009).