How do I display time? I see that there are several format options but my form is displaying the date and the time.
I am using MySql as my db, and the fields I am trying to display are time fields.
Right now I get a display of the date dd-mm-yyyy and time 00:00:00, meaning I get 00:00:00 no matter what record I look at.
did you try a field-format: HH:mm:ss ?
Yes I tried that, and it does not display the time. I had a similar problem with Cold Fusion outputting the same data. Could this be driver issue? Or am I missing something really easy?
Ok the time issue is all better, but the date is displaying as 1970, instead of 2004. The database should only go back to 2003 and only a few records at that.
What did you mean by: all better?
What did you do, what did you change?
P.S. In Servoy, if you use only the timecomponent the date component is set to 01-01-1970
Actually I did several things, first I doublechecked the format was set to what you suggested, and tried some of the other formats, eventually going back to what you suggested.
Then I also updated the driver for MySQl (I had recalled reading a post about a newer version)
Lastly, I made sure that there was no “Test” records in the database, of which there was a few.
P.S. In Servoy, if you use only the timecomponent the date component is set to 01-01-1970
I guess what i really need to know, can I have the field(s) just display the time and not the date as well? Is this what you mean?
This is my first solution in Servoy, so I’m still in the learning phase.
Yes, you can show only the time-component by formatting the field as, for example: HH:mm