Merging a Date & Time field in HANA Model to create a timestamp

[Former Member]

I have 2 seperate columns in hana graphical calculation view that I want to concatenate together into a time stamp there is no concat function in the calculation library.  Has anyone been able to do this in HANA?  I have the fields in DT & TM data types as well as string types.

[Former Member · Accepted solution]

Hi Alex,

You can use + sign to concatenate and longdate function to convert it to timestamp data type.

use the below one as example.

longdate(string('2014-01-21') +string(' ')+ string('10:20:15')+string('.123456'))

if you have columns already in string data type then no need to use string() function.

if you have just secondate which means no m.seconds, then use the below syntax.

seconddate(string('2014-01-21') +string(' ')+ string('10:20:15'))

Regards,

Venkat N.