No month format for Win's M format? Date format problem with LabSQL.

[astroboy]

Hi

I encountered a problem.

I noticed that there is no month format for MS Window's month format, M while we have %m for window's MM format.

In short, we have M means 1-12 and MM means 01 -12 in MS window. In NI Labview we only have %m  that means 01-12 but no format for M.

Lately I have problem with the date/time conversion with LabSQL.

In the table, I created a column "time_stamp" with the type as timestamp. By right, when querying  the date and time from database,

it produces result in the format as defined  in window, instead of timestamp type.

Please advise.

Clement

(Using Labview 7.1, LabSQL, ADO toolkit)

[TCPlomp]

Maybe you can use the

<%x>	locale-specific date

Formatter?

Ton