hello,
I have two variables
var1 is the Date : YYYYMMDD
var2 is the time : HHMMSSTH
and I would like to concatenate those two variable in one, with the timestamp format ?
Thank you for your help
yyyymmdd to timestamp
Moderators: chulett, rschirm, roy
Re: yyyymmdd to timestamp
I tried this but it give me an error
StringToTimestamp(%DSLink8.PutDate:Left(DSLink8.PutTime,8)
%,[%"%yyyy%mm%dd %hh%nn%ss"%])
StringToTimestamp(%DSLink8.PutDate:Left(DSLink8.PutTime,8)
%,[%"%yyyy%mm%dd %hh%nn%ss"%])
Re: yyyymmdd to timestamp
I'm still trying things,
StringToTimestamp( "2015-01-01 11:11:11" ,'%YYYY-%MM-%DD %hh:%nn:%ss')
But this simple expresion give me an error
Transformer_6,1: Caught exception from runLocally(): APT_ParseError: Parsing parameters "%YYYY-%MM-%DD %hh:%nn:%ss" for conversion "timestamp=timestamp_from_ustring[%yyyy-%mm-%dd %hh:%nn:%ss](ustring)": APT_Conversion_String_TimeStamp: Invalid format [%YYYY-%MM-%DD %hh:%nn:%ss] used for string_from_time type conversion.
StringToTimestamp( "2015-01-01 11:11:11" ,'%YYYY-%MM-%DD %hh:%nn:%ss')
But this simple expresion give me an error
Transformer_6,1: Caught exception from runLocally(): APT_ParseError: Parsing parameters "%YYYY-%MM-%DD %hh:%nn:%ss" for conversion "timestamp=timestamp_from_ustring[%yyyy-%mm-%dd %hh:%nn:%ss](ustring)": APT_Conversion_String_TimeStamp: Invalid format [%YYYY-%MM-%DD %hh:%nn:%ss] used for string_from_time type conversion.
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India