Timestamp

[pgarcia75]

Hello

I have a MySql table with two fields: Date Msg (date type) and TimeMsg (type time).

I wish to load these two fields and create a new create with these two fields:

RDV:

LOAD
  DateMsg,
  TimeMsg,
  Timestamp (DateMsg & '' & TimeMsg) as tsMsg;
From ...

But, it does not working
Who can help me ?
Thanks
P

[anushree1]

Please use 

Timestamp( FieldName ,'YYYY-MM-DD hh.mm'

 or 

Timestamp(Timestamp#(Fieldname))

[pradosh_thakur · Accepted solution]

If your date and time are dates and times and not string then try

Timestamp (num(DateMsg)+ num(TimeMsg) )as tsMsg;

[pgarcia75]

Thanks