PDA

View Full Version : SQL time



Peter van Mil
15-Jan-2014, 12:24 PM
I am very happy with the improved support of SQL datatypes in the Studio. I have been testing with time fields and found something strange. I have set the Form_Datatype to Mask_Time and the Form_Mask to "hh:mm". When I enter "08:15" the time is converted to "20:15" after the save. In the database it still is "08:15:00".

Times, that are "00:00:00" in the database are shown as "12:00". If I remove the Form_Mask, the time is displayed correctly.

So there seems to be something wrong with the Form_Mask (and European times).




Set Form_Datatype to Mask_Time
Set Form_Mask to "hh:mm"


7279

Dennis Piccioni
16-Jan-2014, 04:22 PM
Hi Peter,

thanks for your report. I have reproduced this here and we're looking into it.

Peter van Mil
16-Jan-2014, 05:08 PM
Hi Dennis,

Fine. I thought it might be a European date/time issue, so I am glad that you can reproduce it.

Peter van Mil
27-Jan-2014, 11:52 AM
I have tested a fix for this and it works!

Dennis Piccioni
27-Jan-2014, 12:23 PM
Thanks Peter,

that fix should be in the next public 18.0 build.