Concatenate Two string

Shruthi · Post by **Shruthi** » Mon Feb 09, 2009 3:36 am

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?

vjonnala1516 · Post by **vjonnala1516** » Mon Feb 09, 2009 5:03 am

Hi choose the following function from transformer Date&Time

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

Shruthi · Post by **Shruthi** » Mon Feb 09, 2009 5:36 am

Thanks VJ. This helped

chulett · Post by **chulett** » Mon Feb 09, 2009 8:11 am

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.