Re: date format conversion from MySQL

Hi Kenny K. thanks
All data in the database is saved in the year 2007 and will be saved on onbwards so I dun think the year issue  is a big issue.
 
Yes I am using LabSQL and I have already learned these in the website U mentioned.
 
Ok it is working. All I have to do is to convert the format so that it can be read correctly.
 
However,  it acts strange.  In the database,  the date is formated as 0000-00-00 00:00:00 and the type is datetime as I created.
 
In WinXP, the simple labview progran reads as 12/18/2007 2:45:24 PM while in win2K it reads, 18-Dec-06 14-51-25.
How can I resolve these problems? Looks I have to make 2 programs for each platform?
 
Pls advise
Clement     

astroboy wrote:Hi Ravens. I think that not all computers have the same settings. Is there a way how can make sure that it still works despite of different settings in esch PC?By auto-changing registry? Clement

There probably is a way to do that, but I don't know how.  I don't think it is a good idea to change the PC settings in that way because it would interfere with all other programs on the PC.  Suppose the user wants the format of date and time to remain the way it is for other programs or looking at file/directory properties.
Rather than basing your functions on the system format settings, use the format string functions within labview that will make the date/time to appear the way you want it to.  Look at the format date/time string function on the timing palette.  Also, format into string on the string palette.

Re: date format conversion from MySQL - labview