Issue Details
I'm using Database Connectivity Toolkit to write data to a MySQL database from LabVIEW. I need to create a table containing a column of date/time datatype, thus I used
DB Tools Insert Data VI (setting create table? input to True) to create the table and
DB Tools Format Datetime String VI to return a date/time string to be written to the database:
However, after executing the VI, the table created in the MySQL database only contains the date information and not time information.
Creating the table using
DB Tools Create Table VI leads to the same problem.