Page 1 of 1

Concatenate Two string

Posted: Mon Feb 09, 2009 3:36 am
by Shruthi
Hi.. I have a requirement where I have to concatenate a date field and time field and send it to Timestamp field. How to achieve this?
My thought was to convert both date and time into string and concatenate them and later convert from string to timestamp?
Is this is the correct approach. I'm also not sure of how to implement this?

Can someone help?

Posted: Mon Feb 09, 2009 5:03 am
by vjonnala1516


Hi choose the following function from transformer Date&Time

TimestampFromDateTime(%date%,%time%), where date should be Y-M-D format.

Thanks VJ

Posted: Mon Feb 09, 2009 5:36 am
by Shruthi
Thanks VJ. This helped

Posted: Mon Feb 09, 2009 8:11 am
by chulett
To answer the question as asked, the colon is the concatenation operator so you could use it to put the two strings together and then convert that string to a timestamp.