This content has been marked as final. Show 2 replies
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.