[AccessD] MySQL / VBA Now() format

[Stuart McLachlan]

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
>