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.