2 Replies Latest reply on Aug 24, 2015 7:17 PM by Morgan Kisienya

    Teiid parsetimestamp

    Morgan Kisienya Newbie

      Hi all,

       

      Your help is much appreciated.

       

      I am using parsetimestamp to export data from CSV into MySQL.

       

      An example of date format on CSV is "Mar 17 2009  9:00PM"

       

      On teiid designer I have the following;

       

      DECLARE timestamp VARIABLES.@datecreated = (SELECT PARSETIMESTAMP(VARIABLES.@createdate, 'MMM dd yyyy hh:mm'));

       

      When the data goes over to MySQL it all appears as AM.

       

      How do I tell the parsetimestamp version to also evaluate the suffix AM or PM.

       

      Regards

       

      Morgan