MySql to FM

[Omer]

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

[Our Town]

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.

[Omer]

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