Jump to content

MySql to FM


Omer
 Share

This topic is 5717 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

  • Newbies

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

Link to comment
Share on other sites

This topic is 5717 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.