[AccessD] MySQL / VBA Now() format

[kost36 at gmail.com]

Hi Stuart,
It was the first I tried but doesn't work for me
/kostas

-----Original Message-----
From: AccessD <accessd-bounces+kost36=gmail.com at databaseadvisors.com> On
Behalf Of Stuart McLachlan
Sent: Tuesday, January 24, 2023 2:31 AM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] MySQL / VBA Now() format

I just use a plain:
sSQL = .......... , Now() as dtg, .....

and it works fine  for updating a Timestamp with MySQL ODBC Driver 8.0.0.

-- 
Stuart


On 23 Jan 2023 at 21:20, kost36 at gmail.com wrote:

> Hey all,
> I use a MySQL table connected to an access form via ODBC driver
> (8.0.3) and I have a problem saving a timestamp field. The record in
> MySQL is "yyyy-mm-dd HH:mm:ss" Based on my pc regional settings ms
> access shows it as "dd-mm-yyyy HH:mm:ss". I use Format(Now(),
> "yyyy-mm-dd HH:mm:ss") but it doesn't make any change. Am I missing
> something ? Thank's
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com