Teiid parsetimestamp

[kisienya]

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

[shawkins]

From http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

You should be able to use "a" in the pattern - 'MMM dd yyyy hh:mma'

[kisienya]

Thanks Steven.