sql error when time stamp is entered

[shamaran]

hai good morning,

im writing a programme to save date to SQL express. i had a connectivity problem but manage to get the solution. My prob is when i save a random number i dont have any poblem but i need to save it according to time. when i entered the time stamp in string an error occured. i have attached picture of my block diagram and error massage . looking forward for sum help. thanks

regards,

shamaran

 

[KateB]

Have you checked C:\Program Files\National Instruments\LabVIEW 2009\manuals\DCT_User_Manual.pdf (it probably in other LabVIEW folder, depend on your version)?
It has a discussion on using DB Tools Format Datetime Str.vi to write a date/time format as shown in its page 6-4.
Please give it a try.

[FraggerFox]

Your sql query in the code is wrong.

The format for date-time is

%d/%d/%d 0:0:1

Eg: 10/28/2009 12:23:10

Date format is in (MM/DD/YYYY)

Time format is in HH:MM:SS

[FraggerFox]

Replace - with /

[shamaran]

hai guys,

thanks for all the kind reply. after few testing i found out the output from the variant is not in the same order as i wired to the  bundle by name.

even the array shows in the same arrangment as in my sql. i rewired the whole thing again and it turn to be ok.

Do place a indicator on variant output . i saw a lot of problem do occur when we change data to variant type

have a nice day guys

regards,

shamaran