Hello,

I'm importing from a MySql to FileMaker 6 using Actual Technologies' ODBC driver. Works good. The problem is a timestamp field(column) in MySql is automatically formated to a date format (mm/dd/yy) when it gets in FileMaker. Is this being done by FileMaker or the Actual driver?

The FM field is a number field; or it can be text field. Either way the MySql format is automatically changed to the FM format.

The MySql timestamp format is yyyymmddhhmmss. I need it to import into FM in the same format.

Thank you,

Omer

I wish I could give you the answer as I posted this question some time ago without any luck... I will hope for the same... I know I tried in my querey running the proper conversion but still nothing. Not even in filemaker 8.

Jonathan Monroe of Actual Technologies kindly solved this problem. The conversion is apparently done by FM when it detects a timestamp field.

Inserting

SELECT CAST(my_timestamp As CHAR) from my_table

into the FM SQL Builder forces FM to treat the timestamp field as a text field.

Does the job.

Omer