NAV DateTime TO MySQL

itinkiam

I had the ADO connection working and sending DateTime to SQL with little trouble. But now, the customer has told me that my connection is to MySQL. We are porting over our connections and having trouble getting the NAV DateTime into a format that MySQL will accept. Any help would be appreciated. :-k

skulla

What format are you looking for ? Provide more details.

If you want to format a datetime then use FORMAT. for ex: FORMAT(WORKDATE,0,'<Day,2><Month,2><Year4>')

itinkiam

Actually that works! Thank you so much. Simple. :oops: It seems that I can never get the syntax for the format of a date correct.