string to timestamp error
Posted: Thu Dec 02, 2010 3:59 pm
Hi My input field is Timestamp but since i was missing the milliseconds from the field i am converting it into char field to get the missing milliseconds.
so
My sql : select convert(char(23),update_dt,9)) as update_dt from table.
My source Data value is
Feb 17 1995 12:00:00:000AM(Varchar (26))
when i am trying ti convert it using
StageVar1 = Trim(input.coloumn(Varchar(26))
StringToTimestamp(StageVar1,'%yyyy-%mm-%dd %hh:%nn:%ss.6') i am getting following error.
APT_CombinedOperatorController(1),0: Data string 'Feb 17 1995 12:00:00:00' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss.6': an integer was expected to match tag %yyyy.
APT_CombinedOperatorController(1),0: Conversion error calling conversion routine timestamp_from_string data may have been lost
APT_CombinedOperatorController(1),0: Data string 'Feb 17 1995 12:00:0' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected to match tag %yyyy.
APT_CombinedOperatorController(1),0: Conversion error calling conversion routine timestamp_from_string data may have been lost
so i tried
StringToTimestamp(StageVar1,'%mon %dd %yyyy %hh:%nn:%ss.6') then i am getting folllowing error.
APT_CombinedOperatorController(1),0: Data string 'Feb 17 1995 12:00:00:000AM' does not match format '%mon %dd %yyyy %hh:%nn:%ss.6': an integer was expected to match tag %m.
APT_CombinedOperatorController(1),0: Conversion error calling conversion routine timestamp_from_string data may have been lost
APT_CombinedOperatorController(1),0: Data string 'Feb 17 1995 12:00:0' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected to match tag %yyyy.
Please any suggestions..
so
My sql : select convert(char(23),update_dt,9)) as update_dt from table.
My source Data value is
Feb 17 1995 12:00:00:000AM(Varchar (26))
when i am trying ti convert it using
StageVar1 = Trim(input.coloumn(Varchar(26))
StringToTimestamp(StageVar1,'%yyyy-%mm-%dd %hh:%nn:%ss.6') i am getting following error.
APT_CombinedOperatorController(1),0: Data string 'Feb 17 1995 12:00:00:00' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss.6': an integer was expected to match tag %yyyy.
APT_CombinedOperatorController(1),0: Conversion error calling conversion routine timestamp_from_string data may have been lost
APT_CombinedOperatorController(1),0: Data string 'Feb 17 1995 12:00:0' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected to match tag %yyyy.
APT_CombinedOperatorController(1),0: Conversion error calling conversion routine timestamp_from_string data may have been lost
so i tried
StringToTimestamp(StageVar1,'%mon %dd %yyyy %hh:%nn:%ss.6') then i am getting folllowing error.
APT_CombinedOperatorController(1),0: Data string 'Feb 17 1995 12:00:00:000AM' does not match format '%mon %dd %yyyy %hh:%nn:%ss.6': an integer was expected to match tag %m.
APT_CombinedOperatorController(1),0: Conversion error calling conversion routine timestamp_from_string data may have been lost
APT_CombinedOperatorController(1),0: Data string 'Feb 17 1995 12:00:0' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected to match tag %yyyy.
Please any suggestions..